Re: calling sqlplus from unix shell script error

From: Brian Peasland <dba_at_remove_spam.peasland.com>
Date: Tue, 9 Sep 2003 17:35:43 GMT
Message-ID: <3F5E0F6F.C5827A15@remove_spam.peasland.com>

> The script:
>
> sqlplus<<! > $CometsLog/create-tst92.log sys/system

Note that you have "sys/system". This is probably not a valid userid/pswd combination. But then again, it may just be that you modified it so that I don't know your password.  

Why not just code your script as follows?:

---

sqlplus /nolog <<EOF > $CometsLog/create-tst92.log

connect sys/pswd as sysdba

exit
EOF

---

Make sure that the 'EOF' starts in column 1 of your text file.

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"

Received on Tue Sep 09 2003 - 12:35:43 CDT