Re: sqlplus return codes on unix
Date: 1997/01/04
Message-ID: <dlscott-0401971202410001_at_user-37kb6qc.dialup.mindspring.com>#1/1
In article <32cbc5ed.3223877_at_n5.gbso.net>, chuckh_at_dvol.com (Chuck Hamilton) wrote:
> Is there a way to get the full return code from SQLPLUS back to a unix
> shell script? Unix only looks at the low-order byte. Is there perhaps
> a specific shell that'll get a two byte return code?
Instead of worrying about the return code, I've created a wrapper for SQL*Plus in our unix environment. The wrapper script causes a log file to be written, then greps (we use egrep) out "ORA-" and "error", and then sets its own error code appropriately.
We use this approach with both sqlplus and sqlldr. In addition, we place comments in our script of the form "--IGNORE ORA-xxxxx", which allows egrep to ignore non-critical errors (index exists, etc.).
Let me know via email if you'd like to see the script. I hope to put it up on the Web in the not-too-distant future.
David Scott ...how can I keep from singing? bumper snicker: My other guitar is a Martin (D16H)email: dlscott_at_mindspring.com
Received on Sat Jan 04 1997 - 00:00:00 CET