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

ORA-06309: IPA: No message queue available

1 Answers  


ORA-19212: no key columns specified before call to DBMS_XMLSTORE.updateXML()

1 Answers  


ORA-00353: log corruption near block string change string time string

1 Answers  


DRG-11304: function-based indexes are not supported by this indextype

1 Answers  


TNS-00007: INTCTL: unknown host

1 Answers  


LSX-00284: duplicate constraint name "~S"

1 Answers  


RMAN-06161: error when inspecting auxiliary filename: string

1 Answers  


QSM-02184: Expression to enable PCT cannot be rolled up

1 Answers  


DRG-11625: MAXURLS * URLSIZE must be less than string

1 Answers  


ORA-02145: missing STORAGE option

1 Answers   Oracle,


ORA-03214: File Size specified is smaller than minimum required

1 Answers  


DRG-11805: Accepted

1 Answers  


Categories