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



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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NID-00335: The following datafiles are not consistent:

1 Answers  


DRG-52208: the specified attribute already exist: string

1 Answers  


NNL-00227: Request-processing delay is currently disabled

1 Answers  


TNS-04205: Trace Assistant Internal ERROR: Memory

1 Answers  


SQL*Loader-00419: input datatype for column string is not supported when loading varrays

1 Answers  






ORA-26534: collision: tranID number ignored and purged

1 Answers  


ORA-31033: Requested number of XML children string exceeds maximum string

1 Answers  


TNS-12546: TNS:permission denied

2 Answers  


ORA-27066: number of buffers in vector I/O exceeds maximum

1 Answers  


ORA-16184: DB_UNIQUE_NAME string hashes to the same value as DB_UNIQUE_NAME string

1 Answers  


SQL*Loader-00427: a field condition references a non-scalar field or a LOB field string

1 Answers  


ORA-19591: backup aborted because job time exceeded duration time

1 Answers  


Categories