looks like oracle changed how sqlplus -s /nolog works in

From: <ryan_gaffuri_at_comcast.net>
Date: Fri, 11 Jan 2008 15:29:28 +0000
Message-Id: <011120081529.9310.47878B58000606890000245E2207022933079D9A00000E09A1020E979D@comcast.net>

Looks like when you log into sqlplus in you get your prompt set up with user_at_database. You used to have to write a login.sql script to do this. However, this appears to have broken a standard way to log into sqlplus from a unix shell. For years I have used...

sqlplus -s /nolog << EOF
EOF Try it. You just hang when you log in.

Also the following is necessary without -s

sqlplus /nolog << EOF
EOF First conn it takes your variable as a variable for the prompt, the second time logs you in.

Rather annoying. I have been on projects where I Have had tons of code written the first way with -s /nolog that would have to be changed.

anyone have a workaround to get -s /nolog to work?

Received on Fri Jan 11 2008 - 09:29:28 CST

Original text of this message