Hi,
I am trying to load the records in a .txt file into the data base using SQL loader. I gave:
$ sqlldr user/pass@DB control=filename.ctl log =mylog.log
It throwed the following error:
SQL*Loader-297: Invalid syntax or bind variable in SQL string for column STATUS.
ORA-01756: quoted string not properly terminated
What could be the reason ??
Follwoing is my .ctl file:
OPTIONS ( SKIP=1)
LOAD DATA
INFILE './matched.txt'
BADFILE './matched.bad'
DISCARDFILE './matched.dsc'
INTO TABLE "DATA"
APPEND
FIELDS TERMINATED BY X'9'
TRAILING NULLCOLS
(RECORD_ID "TRIM(:RECORD_ID)"
,
MATCH_LEVEL "TRIM(:MATCH_LEVEL)"
,
MATCH_IDENTIFIER "TRIM(:MATCH_IDENTIFIER)"
,
TDLINX "TRIM(:TDLINX)"
,
STORE_NAME "TRIM(:STORE_NAME)"
,
STORE_ADDRESS "TRIM(:STORE_ADDRESS)"
,
STORE_CITY "TRIM(:STORE_CITY)"
,
STORE_STATE "TRIM(:STORE_STATE)"
,
STORE_ZIP "TRIM(:STORE_ZIP)"
,
PHONE_NUMBER "TRIM(:PHONE_NUMBER)"
,
STATUS "'I'"
,
DATE_CREATED "SYSDATE"
,
USER_CREATED_BY "SYSTEM"
)