Forum Stats

  • 3,837,185 Users
  • 2,262,234 Discussions
  • 7,900,218 Comments

Discussions

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

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

Hello,

In our recent Oracle 12.0.2.0, 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 ?

Thanks,

Mohamed Boutkhil

Answers

This discussion has been closed.