ORA-22908: reference to NULL table value



ORA-22908: reference to NULL table value..

Answer / guest

Cause: The evaluation of the THE subquery or nested table
column resulted in a NULL value implying a NULL table
instance. The THE subquery or nested table column must
identify a single non-NULL table instance.

Action: Ensure that the evaluation of the THE subquery or
nested table column results in a single non-null table
instance. If happening in the context of an insert statement
where the THE subquery is the target of an insert, then
ensure that an empty nested table instance is created by
updating the nested table column of the parent table's row
specifying an empty nested table constructor.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PLS-00635: method does not override

1 Answers  


ORA-07215: slsget: getrusage error.

1 Answers  


ORA-19000: missing RELATIONAL keyword

1 Answers  


ORA-02058: no prepared transaction found with ID string

1 Answers  


QSM-02007: multiple instances of the same table or view

1 Answers  






SQL*Loader-00603: Maximum length number of column string is too big for bind array

1 Answers  


ORA-19809: limit exceeded for recovery files

1 Answers  


ORA-01162: block size string in file header does not match configured block sizes

1 Answers  


RMAN-06158: validation succeeded for archived log

1 Answers  


ORA-00331: log version string incompatible with ORACLE version string

2 Answers  


DRG-13307: 'off'=string and 'len'=string references character past end-of-file of string character document, at line string

1 Answers  


ORA-28279: Error reading ldap_directory_access init parameter.

1 Answers  


Categories