DSP Blog: Oracle APEX (13)

-->

Latest Posts

11-Jan-2018 10:34:01

ORDS, OAuth2 & Web Services in APEX – Part 3

Calling Web Services from APEX The following blog will show you how to call GET method Web Service from an APEX 5.1 application and extract the response data. It will also show..

21-Dec-2017 10:07:04

Options For Loading Excel Data Into APEX Applications

Excel is still widely used across many organisations as a standard reporting tool, often being used as a substitute for small databases. As a consequence, it has become necessary..

30-Oct-2017 10:08:26

ORDS,OAuth2 & Web Services in APEX – Part 1

I recently gave a presentation on how to get started with Web Services at the UKOUG APEX SIG in London. The first half covered how to create Web Services with ORDS, how to protect..

09-Oct-2017 10:00:47

Validations and Duplicate Page Submissions in APEX 5.1

I had a problem with a modal dialog page in APEX 5.1, which created new rows in a table on the database whenever the Create button was pressed. The problem was that if the user..

19-Sep-2017 10:56:55

QuickSQL – Saves you time

One of the new features of APEX 5.1 definitely changed my way of creating DDL on Oracle databases. With the Quick SQL packaged application you only need to write minimal lines of..

29-Mar-2017 16:41:30

A Review of Interactive Grid in APEX 5.1.1

This blog has been a long time in the making… Of course before writing a blog on any subject, you have to do your research. In my case, my research involved creating dozens (maybe..

28-Mar-2017 15:47:07

Dynamic Theme Style in APEX 5.1

One of the new features of APEX 5.1 is the introduction of APEX_THEME API which enables you to change the application theme style by user.

01-Mar-2017 14:08:56

A complete guide to #ORCLAPEX Dynamic Actions

Last year, Craig Sykes and I were discussing ideas for presentations at Tech16 and one idea made us quite excited to turn in to a paper for submission.

10-Nov-2016 14:17:21

Integrating APEX with Outlook via Exchange Web Services (EWS)

Here at DSP, our employee holiday booking and approval system is (unsurprisingly!) an APEX application. As well as this though, we also maintain a calendar in outlook which after..

27-Sep-2016 17:23:21

Dynamic Selection of Tabs and Region Display Selectors in APEX

I was recently working on a project for a customer who had a requirement for a form to display a tab region (tab container template) with two tab pages, and for the correct tab to..