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 create the queue in the APPLSYS schema.

How to do it...

To create the advanced queue, perform the following steps:

1. 1. Ftp the SQL script XXHR_CREATE_ABS_AQ.sql to $XXHR_TOP/install/ch5.

2. 2. Open a Putty session and change the directory to $XXHR_TOP/install...