Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


SQL*Loader-00480: EXPRESSION may not be used with elements
of a collection.



SQL*Loader-00480: EXPRESSION may not be used with elements of a collection...

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

Post New Answer

More Oracle Errors Interview Questions

TNS-00504: Operation not supported

1 Answers  


ORA-25453: invalid iterator: string

1 Answers  


PLS-00511: a record may not contain a PL/SQL table of records

1 Answers  


EXP-00076: multiple devices specified for tape output

1 Answers  


RMAN-08094: channel string: specifying datafile(s) for proxy restore

1 Answers  






TNS-03512: Used string adapter to resolve the alias

1 Answers  


ORA-16718: failed to locate the database resource

1 Answers  


PLS-00352: Unable to access another database 'string'

1 Answers  


ORA-39087: directory name string is invalid

2 Answers  


LPX-00119: element "~1S" attribute "~2S" must be an unparsed entity

1 Answers  


NZE-28790: NLS string open failure

1 Answers  


PLS-00109: unknown exception name 'string' in PRAGMA EXCEPTION_INIT

1 Answers  






Categories