sunilbains
asked on
SQL*Loader-350: Syntax error at line 11.
Am getting following error, Please advise-
SQL*Loader-350: Syntax error at line 11.
Illegal combination of non-alphanumeric characters
, P_BATCH_ID CONSTANT <<BATCH_ID>>
^
Below is the control file , which works fine without PV_BATCH_ID column. The <<BATCH_ID>> is used to get subsituted value($batchID) from shell script
parameter which is as follows in shell script- sed -e "s%<<BATCH_ID>>%$batchID%g
Below is the Ctrl File-
LOAD DATA
append
INTO TABLE Emp
FIELDS TERMINATED by "|"
TRAILING NULLCOLS
(
EmpID EXPRESSION "seq_id.nextval"
, DATE_ENTERED EXPRESSION "sysdate"
, CD CONSTANT 'N'
, CD1 CONSTANT 'New'
, P_BATCH_ID CONSTANT <<BATCH_ID>>
----
, Id char "rtrim(:Id )"
, Name char "rtrim(:Name )"
)
SQL*Loader-350: Syntax error at line 11.
Illegal combination of non-alphanumeric characters
, P_BATCH_ID CONSTANT <<BATCH_ID>>
^
Below is the control file , which works fine without PV_BATCH_ID column. The <<BATCH_ID>> is used to get subsituted value($batchID) from shell script
parameter which is as follows in shell script- sed -e "s%<<BATCH_ID>>%$batchID%g
Below is the Ctrl File-
LOAD DATA
append
INTO TABLE Emp
FIELDS TERMINATED by "|"
TRAILING NULLCOLS
(
EmpID EXPRESSION "seq_id.nextval"
, DATE_ENTERED EXPRESSION "sysdate"
, CD CONSTANT 'N'
, CD1 CONSTANT 'New'
, P_BATCH_ID CONSTANT <<BATCH_ID>>
----
, Id char "rtrim(:Id )"
, Name char "rtrim(:Name )"
)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
if SQL*Loader is complaining about the "<>" value ... the substitution is not working (but the sed statement looks fine to me) or the wrong CTL file is being executed or something like that.
lwadwell