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-25259: cannot specify protocol for agent

1 Answers  


DRG-12206: tag string already exists in section group string

1 Answers  


NNF-04005: Cannot open inputfile

1 Answers  


ORA-09370: Windows 3.1 Two-Task driver ORACLE task timed out

1 Answers  


ORA-30767: OID type mismatch

1 Answers  






ORA-31406: change source string is referenced by a change set

1 Answers  


NZE-28858: SSL protocol error

1 Answers  


PCC-02404: This indicator variable must be declared as a pointer type

1 Answers  


ORA-19555: invalid LOG_ARCHIVE_MIN_SUCCEED_DEST parameter value

1 Answers  


ORA-08401: invalid compiler name: string

1 Answers  


PLS-00385: type mismatch found at 'string' in SELECT...INTO statement

1 Answers  


SQL*Loader-00903: Database must be at least version number.number.number.number.number for direct path

1 Answers  


Categories