SQL*Loader-00480: EXPRESSION may not be used with elements
of a collection.
- 1 Answers
- 2207 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: The EXPRESSION keyword is followed by a required SQL
string expression and is used to load a column with the
result of the SQL string expression instead of with a value
from the input data file. However, this capability is not
allowed with elements of a collection.
Action: Remove the EXPRESSION keyword and associated SQL
string from the collection element in the control file.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
NZE-28814: Cannot convert a number in Oracle format to native format.
ORA-00123: idle public server terminating
ORA-26505: unexpected internal null
ORA-06913: CMX: error during redirection of connection
ORA-30489: Cannot have more than one rollup/cube expression list
O2F-00334: A user-defined type is listed more than once in the INTYPE file
ORA-30052: invalid lower limit snapshot expression
ORA-14158: too many subpartition descriptions
PLS-00670: sort columns must be simple column names
ORA-32841: invalid value for property string
DRG-11440: operation not supported for the string language
DRG-11705: multilevel jump from string to string
Oracle Errors 
