Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: EXIT SQL.SQLCODE and ksh

RE: EXIT SQL.SQLCODE and ksh

From: Marina Leonardo, Jose Luis <JLMarina_at_Uni2.es>
Date: Fri, 15 Sep 2000 10:32:19 +0200
Message-Id: <10620.117072@fatcity.com>


Hi Lisa,

echo $?, echoes the last return code from a program. But there is a problem: unix program return codes are from 0 to 255 (I think)

HTH

	Joselu
	http://www.oraes.com


> -----Mensaje original-----
> De: Koivu, Lisa [SMTP:lkoivu_at_qode.com]
> Enviado el: jueves 14 de septiembre de 2000 21:56
> Para: Multiple recipients of list ORACLE-L
> Asunto: 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 Qode.com."
Received on Fri Sep 15 2000 - 03:32:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US