Re: Verifying user/passwd from shell script?
From: Pierre Charpenay <pcharpenay_at_unilog.fr>
Date: Fri, 29 Oct 1999 15:05:09 +0200
Message-ID: <38199B84.86FBDFEE_at_unilog.fr>
END Then, if $?=99, your user/passwd (in $connection) is not correct.
Date: Fri, 29 Oct 1999 15:05:09 +0200
Message-ID: <38199B84.86FBDFEE_at_unilog.fr>
Hi,
To control if a user/passwd is correct, you can use this :
sqlplus /nolog >/dev/null <<END
whenever sqlerror exit 99
connect $connection -- with 7.3.4 on AIX, it doesn't exit there desc dual -- so I used this (must work everywhere)exit
END Then, if $?=99, your user/passwd (in $connection) is not correct.
That's all !
Bye
Pierre Received on Fri Oct 29 1999 - 15:05:09 CEST