SQL-02141: Collection descriptor has not been allocated



SQL-02141: Collection descriptor has not been allocated..

Answer / guest

Cause: An unallocated collection descriptor was referenced
in a COLLECTION SET or COLLECTION GET statement.

Action: Allocate the collection descriptor with the EXEC SQL
ALLOCATE statement. e.g. EXEC SQL ALLOCATE :coldesc_p;

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-20280: too many device types

1 Answers  


ORA-32052: failed to start mapping service

1 Answers  


ORA-14457: disallowed Nested Table column in a Temporary table

1 Answers  


DRG-12601: invalid user datastore procedure name: string

1 Answers  


ORA-33014: (XSAGDNGL06) In AGGMAP workspace object, variable operator workspace object cannot be dimensioned by rollup dimension workspace object.

1 Answers  






KUP-02000: wrong message file version (msg number not found)

1 Answers  


NNL-01000: SERVER FAILURE responses received: number

1 Answers  


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

1 Answers  


TNS-00253: Error in reading network configuration data from file string with error string

1 Answers  


ORA-12470: NULL or invalid user label: string

1 Answers  


ORA-29952: cannot issue DDL on a domain index partition marked as LOADING

1 Answers  


ORA-00162: external dbid length string is greater than maximum (string)

1 Answers  


Categories