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-04030: out of process memory when trying to allocate string bytes (string,string)

1 Answers  


ORA-37032: (XSMLTMAINT03) You cannot MAINTAIN partition template workspace object in MULTI mode.

1 Answers  


ORA-31160: max substitution group size string exceeded by "string" (string) for head element "string" (string)

1 Answers  


PLS-00412: list of values not allowed as argument to this function or procedure

1 Answers  


TNS-12631: Username retrieval failed

1 Answers  


TNS-12213: TNS:incomplete PREFERRED_CMANAGERS binding in TNSNAV.ORA

1 Answers  


QSM-02128: does not meet the requirements of a primary key mv

1 Answers  


ORA-07251: spcre: semget error, could not allocate any semaphores.

1 Answers  


ORA-01177: data file does not match dictionary - probably old incarnation

1 Answers  


ORA-38611: FI input cursor's item type is not supported

1 Answers  


PLS-00325: non-integral numeric literal string is inappropriate in this context

1 Answers  


ORA-07601: spguno: $GETJPIW failure

1 Answers  


Categories