Conditional dequeuing of AQMessages from Topic causes EOracleError

[ajeeth]

Using DOA to conditionally dequeue JMS Text messages from Oracle AQ caused the following error

Project DOASub.exe raised exception class EOracleError with message 'ORA-01002: fetch out of sequence ORA-06512: at "SYS.DBMS_AQ", line 333
ORA-06512: at line 10
'

The condition Im using is

TAB.USER_DATA.HEADER.GET_STRING_PROPERTY('type')='ROLL_ID'

It should be noted that if message satisfying the condition exists on the topic, the message does get dequeued properly. Looks like the error is raised when no messages satisfying the condition exists.

Since messages satisfying the condition are dequeued properly and messages not satisfying the condition are not dequeued, I assume that the syntax of the condition is correct.

Is this a bug in DOA?

Regards
Ajeeth

 

[Marco Kalter]

I'm not sure how a "fetch out of sequence" could occur within the DBMS_AQ package. It might be an AQ bug, but I can't find any similar problem reports on Oracle MetaLink. Is this problem reproducible?

 

[ajeeth]

Yes the problem is reproducable and happens only when I try to dequeue with a condition. Dequeuing without using conditions seems to work perfectly.

Regards
Ajeeth

 

[Marco Kalter]

Can you send me a demo project for this that reproduces the issue?