开发者

Oracle error:- LRM-00116: syntax error at 'control' following '='

Oracle DB/Windows XP:- I am running an batch file 开发者_StackOverflowthat calls an “.ctl” file which in turn calls an “.xls” file, both present in the same folder. The idea is to load the data onto Oracle db present on an remote oracle server.(non local machine)

I am getting this error, no matter what I do.

Oracle error:- LRM-00116: syntax error at 'control' following '='

The .bat file code is as below

    rem SET SQLLOGIN=remod/P3w1d0ry@wsd

    pause Ready to Load the remo.Temp_data Table

    sqlldr userid=%SQLLOGIN% control=TempData.ctl errors=100 

    pause

The .ctl file is as follows:-
LOAD DATA
INFILE "data.xls"
replace
into table remo.Temp_data
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(
test_abbr "rtrim(:test_abbr)",
test_pk       "rtrim(:test_pk)",
test_sk       "rtrim(:test_sk)",
test_dt       "rtrim(:test_dt)",
test_email       "rtrim(:test_email)",
)


You've remarked out the the SET of SQLLOGIN. Also you might want to put a call in front of the sqlldr statement. You'll also need some data to load...

SET SQLLOGIN=remod/P3w1d0ry@wsd

pause Ready to Load the remo.Temp_data Table

call sqlldr userid=%SQLLOGIN% control=TempData.ctl data=mydata.csv errors=100 
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜