ORA-25240: message ID and dequeue condition/correlation ID
specified in dequeue options



ORA-25240: message ID and dequeue condition/correlation ID specified in dequeue options..

Answer / guest

Cause: An attempt was made to dequeue by including both a
message ID and a dequeue condition/correlation ID in the
dequeue options. In the dequeue options, you are permitted
to specify either message ID or dequeue
condition/correlation ID, or neither.

Action: To dequeue a message, specify a message ID or a
dequeue condition/correlation ID in the dequeue options, but
do not specify both. If you want to dequeue in the queue's
sort order, then do not specify either the message ID or
dequeue condition/correlation ID in the dequeue options.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-20506: no backup of archivelog found

1 Answers  


ORA-29868: cannot issue DDL on a domain index marked as LOADING

1 Answers  


ORA-09831: snyStartThread: failed to build the server port set.

1 Answers  


CLSR-01003: Error number encountered during mounting database

1 Answers  


ORA-01898: too many precision specifiers

1 Answers  


DRG-12010: This file already exists - replace existing file?

1 Answers  


TNS-00270: %s: Terminal Error string

1 Answers  


ORA-27216: skgfgsmcs: sbtinfo2 returned a malformed response

1 Answers  


RMAN-10028: network error number-number occurred during remote RPC

1 Answers  


ORA-12452: label tag string already exists

1 Answers  


RMAN-08181: media recovery complete, elapsed time: string

1 Answers  


RMAN-10025: connection is already registered for events

1 Answers  


Categories