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

NNL-00302: Server restarting

1 Answers  


IMP-00076: Missing NLS_NCHAR_CHARACTERSET in props$

1 Answers  


ORA-19361: ONLINE option not allowed with this type of index

1 Answers  


ORA-32133: Cannot get stream from LOB/FILE

1 Answers  


ORA-01914: invalid auditing option for sequence numbers

1 Answers  


ORA-27053: blocksize in file header not a multiple of logical block size

1 Answers  


ORA-31662: metadata transform name can not be defaulted

1 Answers  


ORA-14618: cannot drop the last value of subpartition

1 Answers  


DRG-11115: a value for string must be specified

1 Answers  


NNL-00298: No cache dump currently scheduled

1 Answers  


ORA-24149: invalid rule name

1 Answers  


ORA-25259: cannot specify protocol for agent

1 Answers  


Categories