Creating an advanced queue
We will now create an advanced queue and the messages we put into the queue will trigger our workflow process later in the chapter. The creation of advanced queues is performed by calls to the dbms_aqadm package. Advanced queues are very different from normal database tables. For example, we cannot insert records directly into the advanced queue tables. We must enqueue and dequeue messages to the advanced queue. When we create an advanced queue we will perform the following tasks:
- Create queue table
- Create queue
- Start queue
- Grant ENQUEUE and DEQUEUE privileges to the apps user
Getting started
To perform these actions there is a script in the download bundle called XXHR_CREATE_ABS_AQ.sql. We are going to use this script to ...
Get Oracle E-Business Suite R12 Core Development and Extension Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
