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.