SQL-02142: Collection is NULL



SQL-02142: Collection is NULL..

Answer / guest

Cause: The collection referenced in an EXEC SQL COLLECTION
statement is null.

Action: Check the status of the associated indicator
variable prior to executing an EXEC SQL COLLECTION statement.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-01621: cannot rename member of current log if database is open

1 Answers  


PLS-00386: type mismatch found at 'string' between FETCH cursor and INTO variables

1 Answers  


ORA-04085: cannot change the value of an OLD reference variable

1 Answers  


LSX-00145: attribute "~1S" invalid derived value "~2S"

1 Answers  


ORA-02773: Invalid maximum client wait time

1 Answers  


PCC-01000: You are not authorized to run Pro*COBOL

1 Answers  


QSM-02143: SUM(expr) without COUNT(expr)

1 Answers  


RMAN-05009: Block Media Recovery requires Enterprise Edition

1 Answers  


ORA-12997: cannot drop primary key column from an index-organized table

1 Answers  


EXP-00028: failed to open string for write

1 Answers  


LFI-00103: Seek operation failed.

1 Answers  


ORA-09361: Windows 3.1 Two-Task driver unable to lock context area

1 Answers  


Categories