开发者

sqlplus - command line select statement doesn't use login.sql settings

I have an sh script containing this:

sqlplus -S $JDBC_URL <<EOF
$1;
EOF

That works fine.开发者_Python百科 However, it doesn't pick my formatting preferences from login.sql. Those settings work fine when I start SQL Plus in interactive mode.

Does anyone know how to make my script read login.sql? Is there some other file perhaps?


Depending on the version of sqlplus you are using and the operating system, you likely need to set and export the ORACLE_PATH (linux) or SQLPATH (windows) environment variable to include the directory that contains login.sql.

I just found that past version used to look in the present-working-directory but that was not happening on the linux server I was working on. Setting SQLPATH did not work either because it is used in windows; setting ORACLE_PATH did work.

Attribution for this information


You could use glogin.sql instead - see OraFAQ on SQL Plus

0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜