Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL LOADER

683973Jun 10 2009 — edited Jun 10 2009
HELLO ALL

I am trying to set up an SQL*Loader using fixed length files and I get following error:

SQL*Loader-350: Syntax error at line 16.
Expecting valid column specification, "," or ")", found "CDBCR".
CDBCR POSITION (42:43) CHAR, "DECODE(:CDBCR,'CR','D
^

syntax of the above column is as follows:

CDBCR POSITION (42:43) CHAR, "DECODE(:CDBCR,'CR','DR':CDBCR)"

and I tried that syntax too CDBCR CHAR terminated by ',', and I get following error

Expecting valid column specification, "," or ")", found "CDBCR".
CDBCR CHAR terminated by ',',


Could please someone advice of what should the syntax of that column be?


Regards
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 8 2009
Added on Jun 10 2009
20 comments
3,662 views