The following is the SQL-02141 error message, you can learn the cause and solution of the Oracle SQL error.
SQL-02141: Collection descriptor has not been allocated
Cause: An unallocated collection descriptor was referenced in a COLLECTION SET or COLLECTION GET statement.
Solution: Allocate the collection descriptor with the EXEC SQL ALLOCATE statement. e.g. EXEC SQL ALLOCATE :coldesc_p;
Please wait for the update…