Thank you all. Your suggestions have clarified A LOT
of grey areas for me. I'm not an expert shell
programmer but I can certainly get by on these
suggestions!
Thanks again.
Saira
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Saira Somani
INET: [EMAIL PROTECTED]
Fat
This should get you started
HTH
Jared
SQLPATH=''
USER_INPUT=''
while [ -z "$USER_INPUT" ]
do
echo Please enter a table owner:
read USER_INPUT
done
echo $USER_INPUT
sqlplus /nolog <
set echo on
connect scott/tiger
s
If you already have shell script front end, would it be acceptable to prompt
for the input in the shell script rather than in the procedure?
#!/bin/ksh
echo "ENTER LOGIN"
read USER
echo "ENTER PASSWORD"
stty -echo
read PASS
stty echo
echo "ENTER WHAT IT IS"
read INPUT
sqlplus -s <<-XXX
${U