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

ORA-00354: corrupt redo log block header

1 Answers  


TNS-00017: INTCTL: error while performing NS receive command

1 Answers  


QSM-02096: mv references a named view

1 Answers  


DRG-10709: this preference is referenced by string and cannot be dropped

1 Answers  


IMP-00053: Import mode incompatible with Export dump file

1 Answers  


PLS-00659: constructor method must return SELF AS RESULT

1 Answers  


KUP-04020: found record longer than buffer size supported, number, in string

1 Answers  


DRG-10569: table or column does not exist: string

1 Answers  


ORA-29359: invalid method name string specified for resource plan string

1 Answers  


ORA-09914: Unable to open the ORACLE password file.

1 Answers  


ORA-38429: invalid datatype for a stored attribute: string

1 Answers  


ORA-13828: generated SQL profile name string already exists

1 Answers  


Categories