Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

949968Jul 18 2012 — edited Jul 19 2012

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.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 16 2012

Added on Jul 18 2012

#advanced-queueing, #database-key-features

5 comments

860 views