HomeOracleOracle Error ORA-24036: invalid SORT_ORDER column string specified for queue table

Oracle Error ORA-24036: invalid SORT_ORDER column string specified for queue table

Oracle Error Message

ORA-24036: invalid SORT_ORDER column string specified for queue table

Reason for the Error

The create queue table command was issued with message_grouping set to TRANSACTIONAL and a sort order column other than priority. Only the priority column can be specified in the sort order for queue tables with transactional grouping.

Solution

Change the sort order list in the create queue table command and retry the call.

Share:

Leave a Reply

You May Also Like

Oracle Error Message CLSGN-32767: Internal error. Reason for the Error An unexpected error occurred. Solution Examine the message(s) that accompany...
Oracle Error Message CLSGN-00211: OCR batch operation failed. string Reason for the Error Setting a set of Oracle Cluster Registry...
Oracle Error Message CLSGN-00210: failed to get value for OCR key “string”. string Reason for the Error It was not...