When SQLPLUS exits with a return code of sql.sqlcode, you will get this code
in $?.
The problem is that it's MOD 128, so i'm afraid it won't be very useful.
> ----------
> From: Koivu, Lisa[SMTP:lkoivu_at_qode.com]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Thursday, September 14, 2000 21:55
> To: Multiple recipients of list ORACLE-L
> Subject: 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 - 04:24:58 CDT
