DSP Blog: How to (2)

-->

Latest Posts

Querying an Oracle Database Using Amazon Alexa

At the UKOUG Tech17 conference last year, I delivered a presentation called APEX and the Internet of Things. As part of this presentation, I wanted to demonstrate how to query the..

Read More

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..

Read More

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..

Read More

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..

Read More

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.

Read More

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..

Read More

Chunked Upload and Download in APEX

Uploading and downloading files is handled well out of the box in APEX. The file upload item type allows you to easily give users the facility to upload files. There is also the..

Read More

Accessing values from the left hand side of an APEX Shuttle

In APEX, the value of the shuttle item is a colon delimited string representing the contents of the right hand side.

Read More

JavaScript Debugging in APEX 5 (at last)

In APEX 4.2, I would debug JavaScript code using the alert() function. I would use this to show information about variables and the steps taken through code.

Read More