SQLPLUS question
From: Murty Adavi <adavi_at_mediaone.net>
Date: Tue, 18 Dec 2001 01:56:01 GMT
Message-ID: <RmxT7.17273$Sj1.9818420_at_typhoon.ne.mediaone.net>
[Quoted] I am calling 'sqlplus' in a shell script and passing login & password info through environment variables.
Is there any way of making 'sqlplus' NOT prompt 3 times for correct login/password ?
In other words, I want sqlplus return an error status upon encountering incorrect login/password without
waiting for correct login & password, so that I can trap the exit code on the next line and take appropriate action.
Date: Tue, 18 Dec 2001 01:56:01 GMT
Message-ID: <RmxT7.17273$Sj1.9818420_at_typhoon.ne.mediaone.net>
[Quoted] I am calling 'sqlplus' in a shell script and passing login & password info through environment variables.
Is there any way of making 'sqlplus' NOT prompt 3 times for correct login/password ?
In other words, I want sqlplus return an error status upon encountering incorrect login/password without
waiting for correct login & password, so that I can trap the exit code on the next line and take appropriate action.
Eg. I want to set up the following C shell script as a cron job....
sqlplus $USERID/$PASSWD _at_$MYORASID @script.sql if($status != 0) then
exit 1
endif
When the env. variable USERID is set to an incorrect login, the control is
indefinitely waiting at the first line
for the correct login info.
Received on Tue Dec 18 2001 - 02:56:01 CET