Oracle Solution for Error ora-24036

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

What triggered the Error:

e 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.

What should we do to fix it:

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