RE: Unix bourne shell HELP

From: Brian MacLean <bmaclean_at_homebid.com>
Date: Mon, 19 Jun 2000 12:36:48 -0700
Message-Id: <10533.109762@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01BFDA25.B5F83150
Content-Type: text/plain;

charset="iso-8859-1"

#!/bin/sh

sqlplus /nolog <<EOF
connect internal
select * from cat;
exit;
EOF Brian P. Mac Lean
Senior Oracle Database Administrator
OCPv8/Oracle Master
HomeBid.Com
8700 N. Gainey Center Drive
Scottsdale, AZ 85258

Tel:480.609.4624 
Cel:602.617.6075 
Fax:480.609.4646 
Net:brian.maclean_at_homebid.com

-----Original Message-----
From: Mr. Majestic [mailto:rc_at_neomenia.com] Sent: Monday, June 19, 2000 12: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

select * from cat;

exit

------_=_NextPart_001_01BFDA25.B5F83150
Content-Type: text/html;

charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">

<META content="MSHTML 5.00.2722.2800" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV>
<DIV><FONT color=#0000ff face=Arial size=2>#!/bin/sh</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2><FONT color=#0000ff><FONT face=Arial>sqlplus /nolog<SPAN
class=229592219-19062000>  <<EOF</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2>connect internal</FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2>select * from cat;</FONT></DIV>
<DIV><FONT size=2><FONT color=#0000ff><FONT face=Arial>exit<SPAN
class=229592219-19062000>;</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT size=2><FONT color=#0000ff><FONT face=Arial><SPAN
class=229592219-19062000>EOF</SPAN></FONT></FONT></FONT></DIV></DIV>
<P><B><FONT color=#0000ff face="Comic Sans MS">Brian P. Mac Lean</FONT></B>
<BR><FONT color=#808080 face="Comic Sans MS" size=1>Senior Oracle Database
Administrator</FONT> <BR><FONT color=#808080 face="Comic Sans MS"

size=1>OCPv8/Oracle Master</FONT> <BR><FONT color=#808080 face="Comic Sans MS" 
size=1>HomeBid.Com</FONT> <BR><FONT color=#808080 face="Comic Sans MS" 
size=1>8700 N. Gainey Center Drive</FONT> <BR><FONT color=#808080 
face="Comic Sans MS" size=1>Scottsdale, AZ&nbsp; 85258</FONT> <BR><FONT 
color=#808080 face="Comic Sans MS" size=1>Tel:480.609.4624</FONT> <BR><FONT 
color=#808080 face="Comic Sans MS" size=1>Cel:602.617.6075</FONT> <BR><FONT

color=#808080 face="Comic Sans MS" size=1>Fax:480.609.4646</FONT> <BR><FONT color=#808080 face="Comic Sans MS" size=1>Net:brian.maclean_at_homebid.com</FONT>
</P>
<P> </P>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">

<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Mr. Majestic [mailto:rc_at_neomenia.com]<BR><B>Sent:</B> Monday, June 19, 2000 12:51 PM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> Unix bourne shell HELP<BR><BR></DIV></FONT> <DIV><FONT face=Arial size=2>I'm executing this bourn shell script below. When I cal</FONT><FONT face=Arial size=2>l the file to execute, I'm only getting logged on to sql plus with sqlplus /nolog. </FONT></DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT face=Arial size=2>How can I get the other statements to execute??</FONT></DIV>

  <DIV>&nbsp;</DIV>
  <DIV><FONT face=Arial size=2>thanks</FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT face=Arial size=2>#!/bin/sh</FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT face=Arial size=2>sqlplus /nolog</FONT></DIV>
  <DIV><FONT face=Arial size=2><BR>connect internal</FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT face=Arial size=2>select * from cat;</FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT face=Arial size=2>exit<BR></FONT></DIV></BLOCKQUOTE></BODY></HTML>

Received on Mon Jun 19 2000 - 14:36:48 CDT