SQL LOADER
683973Jun 10 2009 — edited Jun 10 2009HELLO 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