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

NCR-02007: NCRF: Invalid format descriptor received

1 Answers  


ORA-28279: Error reading ldap_directory_access init parameter.

1 Answers  


ORA-02279: duplicate or conflicting MINVALUE/NOMINVALUE specifications

1 Answers  


ORA-03242: Tablespace migration retried 500 times

1 Answers  


PCC-00051: Size of VARCHAR string is larger than 65533 in line number in file string

1 Answers  






NNL-00230: Controller NOCONFIRM mode is currently string

1 Answers  


ORA-30112: multiple values not allowed for parameter 'string'

1 Answers  


ORA-32609: missing REFERENCE keyword in MODEL clause

1 Answers  


ORA-02236: invalid file name

1 Answers  


ORA-12522: TNS:listener could not find available instance with given INSTANCE_ROLE

1 Answers  


ORA-12722: regular expression internal error

1 Answers  


LFI-00150: Error on creating hash table in function string

1 Answers  


Categories