I need to execute a .ksh from command line. The ksh calls a control file and has 3 parameters. First parameter is a csv file, second the target table in oracle and third parameter is a date parameter.
I am attempting the below from the ksh command line
{code} => testfile.ksh filname.csv targettablename '01-JAN-1900' {code}
and get the below error.
{code} SQL*Loader-350: Syntax error at line 101.
Expecting "," or ")", found "-".
VAR_DATE CONSTANT 01-JAN-1900,
{code}
Could it be that "-" is not acceptable in UNIX? I tried using "/" by giving 01/01/1900 in command, but does not work. Any suggestions?