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