RE: Unix bourne shell HELP

From: Norris, Greg <Greg_Norris_at_mail.dor.state.mo.us>
Date: Mon, 19 Jun 2000 14:31:27 -0500
Message-Id: <10533.109761@fatcity.com>

You're not redirecting any input into sqlplus... try it like this:

• CUT ----------
  #!/bin/sh
  sqlplus /nolog <<__EOF__ connect internal select * from cat; exit __EOF__
• CUT ----------

Note that the final "__EOF__" *must* begin in column one.

-----Original Message-----
From: Mr. Majestic [mailto:rc_at_neomenia.com] Sent: 19 June, 2000 2:51 PM
To: Multiple recipients of list ORACLE-L Subject: Unix bourne shell HELP

I'm executing this bourn shell script below. When I call the file to execute, I'm only getting logged on to sql plus with sqlplus /nolog.  

How can I get the other statements to execute??

thanks

#!/bin/sh

sqlplus /nolog

connect internal Received on Mon Jun 19 2000 - 14:31:27 CDT