- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 67 Insurance
- 536.8K On-Premises Infrastructure
- 138.5K Analytics Software
- 38.6K Application Development Software
- 5.9K Cloud Platform
- 109.5K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
After notification received PL/SQL Call back doesn't trigger
In our recent Oracle 22.214.171.124, 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 ?