ORA-25243: CONSUMER_NAME cannot be specified when dequeuing
from exception queue string.string



ORA-25243: CONSUMER_NAME cannot be specified when dequeuing from exception queue string.string..

Answer / guest

Cause: An attempt was made to dequeue from an exception
queue by specifying the CONSUMER_NAME in the dequeue
options. CONSUMER_NAME can only be specified when dequeuing
from a normal queue created for multiple consumers.

Action: Specify only the message id in the dequeue options
to dequeue a message from an exception queue.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

DRG-10549: length of the object name string exceeded the limit

1 Answers  


TNS-00126: Missing Connection Manager name and address in TNSNET.ORA

1 Answers  


ORA-32109: invalid column or parameter position

1 Answers  


ORA-01051: deferred rpc buffer format invalid

1 Answers  


NCR-00002: NCR: Invalid usage

1 Answers  






IMP-00004: invalid username or password

1 Answers  


SQL*Loader-00525: OCI return status: success

1 Answers  


EXP-00004: invalid username or password

1 Answers  


ORA-38432: EVALUATE operator only allowed on an expression column

1 Answers  


SQL*Loader-00511: Unable to initialize read functions

1 Answers  


RMAN-02005: token too big

2 Answers  


RMAN-06750: SPFILE cannot be backed up by proxy.

1 Answers  


Categories