ORA-24039: Queue string not created in queue table for
multiple consumers



ORA-24039: Queue string not created in queue table for multiple consumers..

Answer / guest

Cause: Either an ADD_SUBSCRIBER, ALTER_SUBSCRIBER, or
REMOVE_SUBSCRIBER procedure, or an ENQUEUE with a non-empty
recipient list, was issued on a queue that was not created
for multiple consumers.

Action: Create the queue in a queue table that was created
for multiple consumers 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-33080: (XSAGDNGL40) In AGGMAP workspace object, you cannot reference dimension workspace object with both a RELATION statement and a DIMENSION statement.

1 Answers  


NNO-00332: warning: region store serial number reduced from number to number

1 Answers  


ORA-02831: Segment deallocation failed - empty segment list

1 Answers  


PROT-00304: Failed to create dump file

1 Answers  


ORA-27014: skgfqpini: translation error while expanding SS_UDMPDIR

1 Answers  






ORA-31405: cannot make changes while change set string is advancing

1 Answers  


ORA-02404: specified plan table not found

2 Answers  


LFI-01512: stat() failed

1 Answers  


ORA-30101: unknown parameter name 'string'

1 Answers  


ORA-31447: cannot create change tables in the SYS schema

1 Answers  


ORA-08004: sequence string.NEXTVAL string stringVALUE and cannot be instantiated

1 Answers  


ORA-36391: (XSMXCLEA01) When CLEAR is used with the STATUS keyword or an AGGMAP, workspace object must be dimensioned identically to workspace object.

1 Answers  


Categories