Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PL/SQL notification / DBMS_AQ.REGISTER

41226Sep 24 2002 — edited Feb 28 2013

There have been a number of discussions on this forum about PL/SQL notifications. I'm running
into the same problem:
- create the notification procedure
- register the procedure
- enqueue a message
- NOTHING HAPPENS
It seems that the notification procedure is not executed.
The discussions on this forum were all inconclusive. Did anybody get this to work? If yes, can
you post an example (i.e. a script that creates the queue, create the procedure, registers the
procedure and enqueues a message)?
Is there a table/view that contains the registrations?
What system parameters are relevant to this functionality?
Where are errors in calling the notification procedure logged?

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 28 2013

Added on Sep 24 2002

#advanced-queueing, #database-key-features

19 comments

14,781 views