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 […]
In this first of a two part article I will demonstrate the use of Oracle Streams Advanced Queuing (AQ) with Application Express. The first part will cover the creating a new queue and adding a message to the queue. Whilst the second part will concentrate on how to dequeue messages. […]
In this article I will explain the method I use when I need to process an indeterminate number of rows using PL/SQL. I became aware of this method after reading Bryn Llewellyn’s white paper Doing SQL From PL/SQL: Best and Worst Practises (My example is based on the code shown on page […]
“It was working yesterday…” Working in any form of shared development environment you will sooner or later hit a problem when something that used to work has either stopped working or is doing something it wasn’t doing before. So how do you find out what have changed? With regards PL/SQL […]
I have in the past struggled with the myriad of formatting options available with dbms_xplan.display_cursor so I was pleased to learn about a quick and easy to remember way of formatting the results at this years UKOUG conference. First execute the SQL statement of interest including the gather_plan_statistics hint: Then run […]
