5 Replies Latest reply on Jul 19, 2012 7:03 AM by 949968

    Is there any way to find out that Oracle queue is empty?

      Hi everyone,

      I am trying to read message from a oracle queue, de-queuing it.
      My code is working fine till Queue has all messages. Once all messages are processed, it is throwing error.

      For example,
      If i have 3 messages in Queue, my code is dequeuing those three messages fine, and then it is going to dequeue Queue again and as a result of it, code is throwing error.

      So, i must get to know, if there is a mechanism to check Queue is empty and then i will stop my code from trying to de-queue the Queue.

      Please help me with this.