Re: Help With WHENEVER Clause
From: Russ Eberle <russ.eberle_at_born.com>
Date: 1996/04/21
Message-ID: <4lc6be$o4j_at_news.mr.net>#1/1
Date: 1996/04/21
Message-ID: <4lc6be$o4j_at_news.mr.net>#1/1
Al Holloway <alh_at_tiger.avana.net> wrote:
>Salutations to all,
>I’m in need of help with using the WHENEVER clause when handling
>errors. In the book, Oracle
>Developer’s Guide, on page 229, it states DO RETURN is an action you can
>direct your program to
>take in a WHENEVER clause. Well I tried that action and got the
>following:
> EXEC SQL WHENEVER SQLERROR DO RETURN;
>
> ...
Do yourself and the C programmers behind you a favor and don't use WHENEVER! Just check SQLCA.SQLCODE after your SQL stmt and do what you gotta do.
Russ Received on Sun Apr 21 1996 - 00:00:00 CEST