Forum Stats

  • 3,854,604 Users
  • 2,264,390 Discussions


After notification received PL/SQL Call back doesn't trigger

MohamedB Member Posts: 9 Red Ribbon
edited Mar 2, 2016 4:57AM in Advanced Queueing


In our recent Oracle, we have implemented the advanced queuing asynchronous notification feature, as it is explained here : Doc ID 235397.1

It works but sometimes it fails without any code change.

Here is the process :

A Message is well enqueued into the queue table. Then we checked if the notification is carried out by querying V$EMON vue, this step works fine but the  message is still in the queue table with status 0 (READY).

We have chacked DBA_SUBSCR_REGISTRATIONS to confirm that the PLSQL procedure is set correctly, it is.

Is anyone know where to look to find what's wrong ?


Mohamed Boutkhil


This discussion has been closed.