Skip to Main Content
  • Questions
  • Priorities not obeyed while dequeing

Breadcrumb

XMAS_TREE

The AskTOM team is taking a break over the holiday season, so we're not taking questions or responding to comments. Please have a happy and safe festive season and as always, thanks for being a member of the AskTOM community.

Question and Answer

Tom Kyte

Thanks for the question, kedar.

Asked: August 05, 2008 - 1:30 pm UTC

Last updated: August 06, 2008 - 12:05 pm UTC

Version: 11.1.0.6.0

Viewed 1000+ times

You Asked

Hi Tom,

I have a queue ordered by priority, enqueue time
and it works great till I add a dequeue condition:

dequeueOption.setCondition("TAB.user_data.title='some condition'");

After which the priorities are obeyed.

I read on the forum that this was a bug in 10g.
http://forums.oracle.com/forums/thread.jspa?messageID=2338502�

Can you please confirm if it is a bug or thats the way its supposed to be.


Thanks in advance.
Kedar

and Tom said...

It is documented that it works that way:

http://docs.oracle.com/cd/B19306_01/server.102/b14257/aq_opers.htm#sthref1286

in 10g (so the poster that said they filed a bug would have had said bug closed as "not a bug")

and 11g

http://docs.oracle.com/cd/B28359_01/server.111/b28420/aq_opers.htm#sthref1301

We're not taking comments currently, so please try again later if you want to add a comment.