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

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

The following is the cause of this 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.

Action you can take to resolve this issue: Change the sort order list in the CREATE QUEUE TABLE command and retry the call.


Tags: Database, Microsoft, Oracle, SQL, Software, DBMS, Error Messages, Directory




Disclaimer:Pak/ed and the contributors are not responsible for any errors contained and are not liable for any damages resulting from the use of this material.  Disclaimer


Related

Home      Disclaimer      Advertise      Contact      Privacy Policy     

Copyright © 2004-16 Paked.com. All rights reserved.

Note: Site best viewed at 1024 x 768 or higher screen resolution