RE: Unix bourne shell HELP

From: Shawn Ferris <Shawn.Ferris_at_twtelecom.com>
Date: Mon, 19 Jun 2000 13:04:02 -0600
Message-Id: <10533.109752@fatcity.com>

You need to use a "here" document... EG:

#!/bin/sh

sqlplus /nolog <<-EOF

    connect internal
    select * from cat;
    exit
EOF HTH
Shawn M Ferris
Oracle DBA - Time Warner Telecom

-----Original Message-----
From: Mr. Majestic [mailto:rc_at_neomenia.com] Sent: Monday, June 19, 2000 12:45 PM
To: ORACLE-L_at_fatcity.com; 'lazydba'
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:04:02 CDT