Re: SQL*Plus question
From: NCR Associate <Narasimha.Kasibhatla_at_DaytonOH.NCR.Com>
Date: 1996/05/17
Message-ID: <DrK2sx.AGK_at_falcon.daytonoh.attgis.com>#1/1
Date: 1996/05/17
Message-ID: <DrK2sx.AGK_at_falcon.daytonoh.attgis.com>#1/1
Actually one can try the following from shell:
echo "Enter User Name: \c"
read user
echo "Enter Password: \c"; stty -echo; read passwd; stty echo
sqlplus -s /nolog <<!EOF! 1>/dev/null 2>&1
WHENEVER SQLERROR EXIT 255 ROLLBACK
WHENEVER OSERROR EXIT 254 ROLLBACK
CONNECT $user/$passwd /* Here one can use shell variables also */
!EOF!
if [ $? -ne 0 ]
then
echo " Password Incorrect"
fi
Hope this helps.
Narasimha Kasibhatla
narasimha.kasibhatla_at_daytonoh.ncr.com
Received on Fri May 17 1996 - 00:00:00 CEST