Question

我有本法典的文字:

sqlldr $ws_usr_eva/$ws_pass_eva@$ws_esq_eva CONTROL=/$HOME/controlfiles/CONTROL_FILE.CTL LOG=/$HOME/batch/log/LOG_FILE.$fecfile.log DATA=/$HOME/batch/input/INPUT_FILE_$fecfile.txt > /$HOME/batch/log/result_loader_eva.ora

变量为:ws_usr_eva、$ws_pass_eva和_ws_esq_eva,在我执行舱单之前填满。我已经检查内容及其ok。

因此,当我管理该书时,它向我显示:LRM-00112:不允许对参数进行控制。

我试图在没有变数的情况下操作文字,并做精细:

sqlldr user/pwd@schema CONTROL=/$HOME/controlfiles/CONTROL_FILE.CTL LOG=/$HOME/batch/log/LOG_FILE.$fecfile.log DATA=/$HOME/batch/input/INPUT_FILE_$fecfile.txt > /$HOME/batch/log/result_loader_eva.ora

我不得不在弹片中使用变数,因为从一个配置文件读到这些变量。

我也尝试用油菜 use灭花=$ws_usr_eva/$ws_pass_eva@$ws_esq_eva 但它没有工作。

Can you help me?

提前感谢。

Answer 1

Incase it helps anybody, you need to enclose your paths (data, control, log) in single qoutes. Double qoutes will not work (although sqlldr will not complain, but rather simply ignore the double qoutes).

Answer 2

In your shell, try to escape your variables::

sqlldr "${ws_usr_eva}/${ws_pass_eva}@${ws_esq_eva}" "CONTROL=${HOME}/controlfiles/CONTROL_FILE.CTL" "LOG=${HOME}/batch/log/LOG_FILE.${fecfile}.log" "DATA=${HOME}/batch/input/INPUT_FILE_${fecfile}.txt" > "${HOME}/batch/log/result_loader_eva.ora"

友情链接