Oracle 错误：- LRM-00116：“控制”后面的“=”语法错误
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/7716335/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Oracle error:- LRM-00116: syntax error at 'control' following '='
提问by vas
Oracle DB/Windows XP:- I am running an batch file that 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)
Oracle DB/Windows XP：- 我正在运行一个批处理文件，该文件调用一个“.ctl”文件，该文件又调用一个“.xls”文件，两者都存在于同一个文件夹中。这个想法是将数据加载到远程 Oracle 服务器上的 Oracle 数据库上。（非本地机器）
I am getting this error, no matter what I do.
无论我做什么，我都会收到此错误。
Oracle error:- LRM-00116: syntax error at 'control' following '='
Oracle 错误：- LRM-00116：“控制”后面的“=”语法错误
The .bat file code is as below
.bat 文件代码如下
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)",
)
回答by Ben
You've remarked out the the SETof 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。此外，您可能希望在 sqlldr 语句前调用。您还需要一些数据来加载...
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
