SQL*Loader-00480: EXPRESSION may not be used with elements
of a collection.
- 1 Answers
- 2185 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 |
IMG-00585: output format does not support the specified channelOrder
PCC-02375: SQL statement found outside the body of a function
PLS-00604: aggregate function is not allowed here
ORA-39088: file name cannot contain a path specification
CLSR-00005: Error encountered during memory allocation
DRG-12438: document table release failed
TNS-12222: TNS:no support is available for the protocol indicated
DRG-12213: cannot create/drop section group or sections for other user
ORA-09776: pws_look_up: access error on (Oracle helper) executable
ORA-01542: tablespace 'string' is offline, cannot allocate space in it
ORA-31635: unable to establish job resource synchronization
ORA-01734: illegal parameters - EXTENT MIN higher than EXTENT MAX
Oracle Errors 
