Skip to Main Content

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!

Notification problems

577744Mar 24 2008 — edited Oct 11 2010
I have a notification PL/SQL callback procedure that only gets invoked when the schema it belongs to enqueues the message. If a different schema enqueues a message, it goes silently into the error queue with max_retries.

My understanding it that without specifying an filter or address that the callback should be invoked for every message placed in the queue, which is the behavior I'm seeking.

What am I missing? Does the queue execute the callback as the schema that enqueues the message? Where can I find out what the problem was?

I'm new to AQ so please assume nothing.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 8 2010
Added on Mar 24 2008
9 comments
2,915 views