OraFAQ Forum: Unix » connecting to oracle from shell script

Home » Infrastructure » Unix » connecting to oracle from shell script

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

connecting to oracle from shell script [message #98471]

Sun, 14 November 2004 14:32

KP
Messages: 4
Registered: March 2001

Junior Member

#UserTest.sh
User()
{
sqlplus /nolog <<EOF
conn / as sysdba
spool /tmp/check_User.out
start /oracle/home/check_User.sql;
spool off
exit
EOF
user=`cat /tmp/check_User.out`
echo $user
}

User

For this shell script i am getting the error
UserTest.sh: syntax error at line 3 : `<<' unmatched

Tell me what changes to do for connecting to oracle database from a korn shell script. Tell me if there is a way to connect to sqlplus -s (to database) it should work for both 8i & 9i.

Thanks !

Report message to a moderator