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

SQL*Loader-00130: Invalid direct path stream size

1 Answers  


DRG-12220: a valid tag must be provided

1 Answers  


PROC-00028: Oracle Cluster Registry already in current version

1 Answers  


ORA-39030: invalid file type string

1 Answers  


DRG-12233: xml sections cannot co-exist with other section types

1 Answers  






ORA-29515: exit called from Java code with status string

1 Answers  


RMAN-06507: trying alternate file for archivelog thread number, sequence number

1 Answers  


ORA-26670: STREAMS option requires COMPATIBLE parameter to be string or higher

1 Answers  


DRG-11804: Created

1 Answers  


DRG-11805: Accepted

1 Answers  


NNL-00345: Save_config_on_stop is currently OFF

1 Answers  


ORA-16798: Unable to complete terminal recovery on the standby

1 Answers  


Categories