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