Shell Programming and Scripting

#!/bin/ksh
# usage $1 = username  $2=pwd, assumes ORACLE_SID and TWO_TASK (if needed) are set 
test_conn()
{
     usr="$1"
     pwd="$2"
     sqlplus -s ${usr}/${pwd}  << EOF | tr -d '[:space:]'
     set feed off
     set head off
     set pages 0
     set verify off
     select 'ok' from dual;
     exit
EOF
}
oops=1
while [ $oops -eq 1]
do
  print 'Enter username: ';  read uname 
  print 'Password: ';  
  stty -echo
     read pass
  stty echo
  result=$(test_conn $uname $pass)
  if [ "$result" = "ok"]  then
     oops=0
  fi

  stty -echo
     read pass
  stty echo

man stty

$ ./test_oracle_conn.sh
./test_oracle_conn.sh[18]: select: bad identifier

$ ./test_oracle_conn.sh
./test_oracle_conn.sh: line 18: syntax error near unexpected token `from'
./test_oracle_conn.sh: line 18: `         select "ok" from dual;'

printf "$FBOLD\nEnter username: $FREG"
read user_name
printf "$FBOLD\nEnter password: $FREG"
read password
printf "$FBOLD\nEnter TNS name: $FREG"
read tns

sqlplus $user_name/$password@$tns | echo "select 'ok' from dual;" > c:/tmp/check_conn.txt