EXIT SQL.SQLCODE and ksh

From: Koivu, Lisa <lkoivu_at_qode.com>
Date: Thu, 14 Sep 2000 15:00:00 -0400
Message-Id: <10619.116997@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_01C01E7D.FBAA399A
Content-Type: text/plain;

charset="iso-8859-1"

Anyone know how to catch this value in a ksh script? I believe I've seen it done before but I just can't remember how. For example:

...ksh script executing

sqlplus lisa/shutup << !
whenever sqlerror exit sql.sqlcode

..statements...
exit;
!

Do something with the error value down here in the ksh script.

Thanks everyone
GO VIKINGS! Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL 33319

V: 954.484.3191, x174
F: 954.484.2933 
C: 954.658.5849

http://www.qode.com

"The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com."

------_=_NextPart_001_01C01E7D.FBAA399A
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>EXIT SQL.SQLCODE and ksh</TITLE>
</HEAD>
<BODY>

Anyone know how to catch this value in =
a ksh script?  I believe I've seen it done before but I just can't = remember how.  For example:

...ksh script executing


sqlplus lisa/shutup << !
 whenever sqlerror exit =
sql.sqlcode


..statements...
 exit;
 !


Do something with the error value down =
here in the ksh script. 


Thanks everyone
 GO VIKINGS!


Lisa Rutland Koivu
 Oracle Database Administrator
 Qode.com
 4850 North State Road 7
 Suite G104
 Fort Lauderdale, FL  =
33319


V: 954.484.3191, x174
 F: 954.484.2933 
 C: 954.658.5849
 <A HREF=3D"http://www.qode.com" =
TARGET=3D"_blank">http://www.qode.com</A>


"The =
information contained herein does not express the opinion or position = of Qode.com and cannot be attributed to or made binding upon = Received on Thu Sep 14 2000 - 14:00:00 CDT