Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

OCI-24036

invalid SORT_ORDER column string specified for queue table

Cause

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.


Action

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