SQL*Loader-00431: illegal NULLIF or DEFAULTIF clause
specified for nested table column string



SQL*Loader-00431: illegal NULLIF or DEFAULTIF clause specified for nested table column string..

Answer / guest

Cause: Rows in a nested table annot be set to NULL. SQLLDR
displays this error when a NULLIF clause was specified for
the element that defines the row that make up a nested
table. SQLLDR also displays this error if a DEFAULTIF clause
is specified for an element that is a named type, since
SQLLDR will set a named type to NULL if the DEFAULTIF
evaluates to TRUE.

Action: none

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

LPX-00656: XSLTVM terminate.

1 Answers  


ORA-01913: EXCLUSIVE keyword expected

1 Answers  


ORA-01663: the contents of tablespace 'string' is constantly changing

1 Answers  


ORA-10574: Test recovery did not corrupt any data block

1 Answers  


EXP-00004: invalid username or password

1 Answers  


ORA-28171: unsupported Kerberos version

1 Answers  


ORA-12201: TNS:encountered too small a connection buffer

1 Answers  


ORA-09822: Translation of audit file name failed.

1 Answers  


NID-00308: Control File string - dbid changed

1 Answers  


ORA-19771: cannot rename change tracking file while database is open

1 Answers  


ORA-04091: table string.string is mutating, trigger/function may not see it

1 Answers  


ORA-40261: input data for model build contains negative values

1 Answers  


Categories