Re: SQL*PLUS and shell scripts

Rob Spies wrote:

> I have also tried passing sql error codes back to the shell script,
> but to no avail. I'd be interested in finding out a way to do this,
> too...
>
> Rob
> rspies_at_minn.net

This is probably considered a hack vs. a real solution. However, what we have traditionally done is to send all of the output to a log file that Unix then does a grep on and looks for ORA- strings. If these are found, then errors are reported.

It, of course, requires that each piece of code (SQL) be pretty modular from the rest. I hope this helps a little.

-- 
====================================================================
Byron Pearce				bpearce_at_csac.com
Systems Consultant			http://www.csac.com
Computer Systems Authority (CSA)	Dallas, Texas

"It's hard to be a ninja when you wear a beeper."