Oracle Apex: Passing a value from a report to a database procedure

This post explains how to pass a value from a Apex classic report to a database procedure. Following a discussion of the objective and a high level overview, the post concludes with a practical demonstration. The example used throughout the post was built using using Apex 19.1 and Oracle Database 19 but this technique should work […]

Writing PL/SQL in Oracle Application Express

There is an excellent article on Writing PL/SQL in Oracle Application Express in the March/April 2014 edition of the Oracle Magazine. There is a lot of useful information about where your code should be located. My favourite part of the article is comparison between the parameterless function relying on the Apex V function and a […]

Queuing for Oracle APEX (Part 2)

In Part 1 of this article I described the steps required to first create a queue and then how to enqueue messages using server side PL/SQL called from an Apex application. In part 2 I will describe the steps required to dequeue the messages and how they may be displayed using Apex. The first step […]