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

ORA-02805: Unable to set handler for SIGTPA

1 Answers  


ORA-09828: SCLFR: atomic latch return error.

1 Answers  


UDE-00006: failed to allocate memory of size number

1 Answers  


ORA-08332: rollback segment #string specified not available

1 Answers  


RMAN-06439: RMAN must be upgraded to version string to work with this package

1 Answers  






TNS-00075: NOTE: the user may get the status info of a remote

1 Answers  


NID-00336: The following datafiles are offline clean:

1 Answers  


ORA-00348: single-process redo failure. Must abort instance

1 Answers  


ORA-31498: description and remove_description cannot both be specified

1 Answers  


SQL*Loader-00132: invalid argument for external table option

1 Answers  


ORA-23411: materialized view "string"."string" is not in refresh group "string"."string"

1 Answers  


ORA-22858: invalid alteration of datatype

1 Answers  


Categories