$ cat xx
#!/bin/ksh
dbcontent=x.dat
echo "Enter userid"
read USERID
echo "Enter passwd:"
stty -echo
read -s PASSWD
stty echo
 
## Start sqlplus in a co-process.
sqlplus -S ${USERID}/${PASSWD} |&
 
## If an interrupt signal is received, close the co-process.
trap 'print -p "exit"' 0 2 3 9 15
 
## Read the list of databases a line at a time.
while read dbname
do
  ## Send commands to the co-process with print -p.
  print -p "connect ${USERID}/${PASSWD}@${dbname}"
  print -p "select ora_database_name from dual;"
  print -p "prompt my name is $USERID and my password is $PASSWD;"
  print -p "prompt DONE" # Indicates end of commands.
 
  ## Read all of the output from the above commands a line at a time into a variable
  ##  called "output".
  while read -p output
  do
     ## If DONE is read, we know we are at the end of expected output so move on.
     if [[ "$output" == "DONE" ]]; then
       break
     else
       print -- "$output"  # Otherwise, print the line to STDOUT.
     fi
  done
done < $dbcontent
 
## Close sqlplus.
print -p "exit;"
 
exit 0
$
$ ./xx
Enter userid
MYUSERNAME
Enter passwd:
<NUNYO_BUSINESS>
ORA_DATABASE_NAME
--------------------------------------------------------------------------------
DB1.WORLD
 
my name is MYUSERNAME and my password is NUNYO_BUSINESS
 
ORA_DATABASE_NAME
--------------------------------------------------------------------------------
DB2.WORLD
 
my name is MYUSERNAME and my password is NUNYO_BUSINESS
 
ORA_DATABASE_NAME
--------------------------------------------------------------------------------
DB3.WORLD
 
my name is MYUSERNAME and my password is NUNYO_BUSINESS
 
ORA_DATABASE_NAME
--------------------------------------------------------------------------------
DB4.WORLD
 
my name is MYUSERNAME and my password is NUNYO_BUSINESS
$