Hi,

I am doing something basic, but I am missing something. Im trying to read the contents of a file and taking those values and connecting to a database. However, it only connect to one (or reads in) value and then exists.

Here is what it looks like:

listname.txt

db1
db2
db3

dbcontent=/usr/home/listname.txt
echo "Enter userid" 
read USERID
echo "Enter passwd:"
stty -echo
read -s PASSWD
stty echo

while read dbname;
do
#Connect to SQLPlus
sqlplus -S  test/test123@$dbname << EOF
select ora_database_name from dual;
prompt my name is $USERID and my password is $PASSWD;
exit;
EOF
done < $dbcontent

sqlplus -S  test/test123@$dbname << EOF

Sorry I forgot to add that. I have that already.

At first sight your code looks correct (save for some minor things which shouldn't matter here), so try to isolate the problem. What does

typeset dbcontent="/usr/home/listname.txt"
typeset dbname=""
echo "Enter userid" 
read USERID
echo "Enter passwd:"
stty -echo
read -s PASSWD
stty echo

while read dbname; do
     echo "DBNAME is: $dbname"
     #Connect to SQLPlus
     #sqlplus -S  test/test123@$dbname << EOF
     #select ora_database_name from dual;
     #prompt my name is $USERID and my password is $PASSWD;
     #exit;
#EOF
done < "$dbcontent"

No, this works just fine. I tried that also to make sure it is actually looping.

Thanks.

Do you get an error (exit status != 0) from the DB operations? In bash (you unfortunately don't mention what system you use), setting the -e option (not shown in your code snippet) will immediately exit on an error condition.

No it works fine. No errors are reported. It executes the script successfully, but only goes through one iteration....its not looping.

Sorry I am using korn shell (/bin/ksh).