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

TNS-12638: Credential retrieval failed

1 Answers  


PCC-00105: Keyword WORK required here by ANSI

1 Answers  


RMAN-10012: KGU error: string

1 Answers  


TNS-00137: Failed to get TNS error message file entry

1 Answers  


ORA-14024: number of partitions of LOCAL index must equal that of the underlying table

1 Answers  


ORA-30111: no closing quote for value 'string'

1 Answers  


ORA-30033: Undo tablespace cannot be specified as default user tablespace

1 Answers  


TNS-04207: Trace Assistant Internal ERROR: Packet Length

1 Answers  


ORA-26002: Table string has index defined upon it.

1 Answers  


LPX-00236: invalid character ~1u ('~2c') found in public identifier

1 Answers  


NID-00396: Reverting database ID from number to number

1 Answers  


NNO-00066: server will perform reload check of administrative region in number seconds

1 Answers  


Categories