-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating

Oracle E-Business Suite R12 Core Development and Extension Cookbook
By :

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
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 create the queue in the APPLSYS
schema.
To create the advanced queue, perform the following steps:
1. Ftp the SQL script XXHR_CREATE_ABS_AQ.sql
to $XXHR_TOP/install/ch5
.
2. Open a Putty session and change the directory to $XXHR_TOP/install...
Change the font size
Change margin width
Change background colour