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

ORA-38201: assert if pin during flush

1 Answers  


LSX-00123: base type is required

1 Answers  


TNS-12615: TNS:preempt error

1 Answers  


PLS-00623: FLOAT precision constraint must be between 1 and 126

1 Answers  


ORA-25184: column name expected

1 Answers  






ORA-13912: Critical threshold value is less than warning threshold value.

1 Answers  


AMD-00100: not found: string "string"

1 Answers   Wipro,


ORA-08433: invalid picture type in convert raw to number

1 Answers  


ORA-16795: Database resource guard detects that database reinstantiation is required

1 Answers  


ORA-15044: ASM disk 'string' is incorrectly named

1 Answers  


ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

1 Answers  


TNS-01106: Listener using listener name string has already been started

1 Answers  


Categories