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-14407: partitioned table contains subpartitions in a different tablespace

1 Answers  


ORA-24812: character set conversion to or from UCS2 failed

1 Answers  


EXP-00029: Incremental export mode and consistent mode are not compatible

1 Answers  


NCR-03018: NCRO: Failed to make RSLV connection

1 Answers  


ORA-02214: duplicate BACKUP option specification

1 Answers  






RMAN-06404: database dismounted

1 Answers  


PLS-00361: IN cursor 'string' cannot be OPEN'ed

1 Answers  


ORA-06525: Length Mismatch for CHAR or RAW data

1 Answers  


ORA-00349: failure obtaining block size for 'string'

1 Answers  


ORA-06309: IPA: No message queue available

1 Answers  


AMD-00130: dimension #string: RDBMS dimension column data type not specified

1 Answers  


RMAN-08060: unable to find archive log

1 Answers  


Categories