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-12449: Labels specified for user must be of type USER

1 Answers  


ORA-09317: szprv: insufficient privileges

1 Answers  


NNC-00001: maximum number of connections already open

1 Answers  


ORA-27412: repeat interval contains invalid keyword: string

1 Answers  


DRG-52204: error while registering index

1 Answers  


ORA-31449: invalid value for change_set_name

1 Answers  


RMAN-10031: RPC Error: ORA-number occurred during call to string.string

1 Answers  


LRM-00100: internal error [number]

1 Answers  


ORA-12056: invalid REFRESH method

1 Answers  


NNO-00320: missing server name parameter

1 Answers  


ORA-06750: TLI Driver: sync failed

1 Answers  


RMAN-08524: input controlfilecopy name=string

1 Answers  


Categories