We are using Oracle Ver - Oracle Database 11g Enterprise Edition Release 188.8.131.52.0 - 64bit Production
I have a C# app which tries to enqueue and dequeue's message into a multiple consumer queue.
I am able to successfully enqueue my payload message into the queue.
But when I try to dequeue the message using both option 1) listen() 2) OracleAQQueue.MessageAvailable event both are not working
1) When I call OracleAQQueue.listen() I get the error message ORA-25295 - Subscriber is not allowed to dequeue buffered messages. I tried to drop the subscriber and add it back, still its of no use.
2) When I register this callback method OracleAQQueue.MessageAvailable it is not getting fired when new message are inserted in the queue.