Message-Id: <10619.116997@fatcity.com> From: "Koivu, Lisa" Date: Thu, 14 Sep 2000 15:00:00 -0400 Subject: EXIT SQL.SQLCODE and ksh 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 EXIT SQL.SQLCODE and ksh

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 =