SQL-02141: Collection descriptor has not been allocated

SQL-02141: Collection descriptor has not been allocated

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;