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