Notification problems
577744Mar 24 2008 — edited Oct 11 2010I 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.