Re: HELP! Oracle Errors & UNIX Shell scripts

In article <sp5l5upjn4t96_at_corp.supernews.com>,   echao_at_interaccess.com wrote:
>
> Hi All:
>
> I've noticed that when I run Oracle SQLLDR and SQLPLUS
> that I really don't have a good way to trap run-time
> errors (e.g. "Ora-012345 Houston, We have a problem...").
>
> I tried trapping problems using $? in kornshell, but
> my script just falls right thru.
>

$? gives return code from entire SQLLDR, SQLPLUS and it is zero. Certain commands may terminate incorrectly, but program is fine.

> Please don't tell me I have to do a grep of the system log file!

But this is what I am doing.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Aug 10 2000 - 00:00:00 CEST