0 Replies Latest reply: Apr 18, 2012 5:38 PM by 906856 RSS

    Oracle Synchoronous and Asynchoronous DEQUEUE not working in

      We are using Oracle Ver - Oracle Database 11g Enterprise Edition Release - 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.

      Any help is greatly appreciated.