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-38772: cannot add datafile 'string' - file could not be created

1 Answers  


ORA-32579: password for SYSTEM already specified

1 Answers  


ORA-04096: trigger 'string' has a WHEN clause which is too large, limit 2K

1 Answers  


ORA-10922: Temporary tablespace group is empty

1 Answers  


NNL-00020: warning: no TNSNAMES.ORA file and no preferred name servers in SQLNET.ORA

1 Answers  






ORA-32590: log group specification not allowed here

1 Answers  


ORA-16073: archiving must be enabled

1 Answers  


ORA-00269: specified log file is part of thread string not string

1 Answers  


ORA-02060: select for update specified a join of distributed tables

1 Answers  


RMAN-06899: updating recovery catalog with new database incarnation

1 Answers  


ORA-23609: unable to find directory object for directory string

1 Answers  


LPX-00227: entity "~S" is not a parsed entity

1 Answers  


Categories