Oracle Database Errors or Warnings from Error ORA-25217 to ORA-25226

SQLServerF1

ORA-25217: enqueue failed, visibility must be IMMEDIATE for queue string.string
Cause: An attempt was made to enqueue to a non-persistent queue without setting visibility to IMMEDIATE.
Action: Set visibility to IMMEDIATE.
ORA-25218: enqueue failed, delay must be zero for queue string.string
Cause: An attempt was made to enqueue to a non-persistent queue with delay greater than zero seconds.
Action: Set delay to zero.
ORA-25219: enqueue failed, sequence deviation not allowed for queue string.string
Cause: An attempt was made to enqueue to a non-persistent queue with sequence deviation specified.
Action: Do not specify sequence deviation.

ORA-25220: enqueue failed, signature not specified for a non-repudiable queue
Cause: An attempt was made to enqueue to a non-repudiable queue without specifying the signature
Action: Give the signature
ORA-25221: enqueue failed, signature specified queue not supporting non-repudiation
Cause: An attempt was made to enqueue to a queue specifying the signature for a queue not supporting non-repudiation
Action: Remove the signature
ORA-25222: enqueue failed, complete sender info. not provided for a queue supporting non-repudiation
Cause: An attempt was made to enqueue to a queue without giving the complete sender information (name) for a queue supporting non-repudiation
Action: Provide the sender information

ORA-25223: user_data type used is not supported
Cause: An attempt was made to enqueue data into a non persistent queue that is of a type other than the supported raw or object type.
Action: Enqueue the message again with data of raw or object type.
ORA-25224: sender name must be specified for enqueue into secure queues
Cause: An attempt was made to enqueue into a secure queue without specifying a sender name.
Action: Enqueue the message with sender name specified.
ORA-25225: invalid value string, DEQUEUE_MODE should be REMOVE or BROWSE or LOCKED
Cause: An invalid parameter has been specified for DEQUEUE_MODE.
Action: Specify either REMOVE, BROWSE or LOCKED.
ORA-25226: dequeue failed, queue string.string is not enabled for dequeue
Cause: The queue has not been enabled for dequeue.
Action: Enable the queue using START_QUEUE.

Above are list of Oracle Database Errors or Warnings from Error ORA-25217 to ORA-25226 received while performing certain operation against Oracle Database or related products.

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *