I am new to AQ. I am implementing AQ within oracle database.
I have two users, test1 and test2.
I have queue1 owned by test1 user and queue2 owned by test2 user.
I want to implement AQ within this queues (queue2 dequeues messages of queue1). I have already implemented AQ for one queue (test2 enqueues and dequeues messages in the queue owned by test1 user.) And please tell me in which cases which one of this types of AQ should I use. Also I would like to know is there any way to dequeue messages from queue2 automatically when they enqueued by queue1 ?
Please first review the following note for an example of how to set up AQ notification:
Note 225749.1 AQ PL/SQL Notification: PL/SQL Callback and Email Notification
If the example works but your notification doesn't, then please follow steps:
Note 1434783.1 Troubleshooting Steps For Advanced Queue PL\SQL Notification