Re: How can I catch a specific ORACLE error in my PRO*C application

From: Ron Reidy <rereidy_at_uswest.net>
Date: Wed, 28 Jul 1999 05:37:38 -0600
Message-ID: <379EEB82.C3067688@uswest.net>

Abiy ALEMU wrote:

> I would like to make something like
> EXEC SQL WHENEVER (SQLCODE = 6502) CONTINUE
>
> I know that I can't do that but I would like to have a possibility to
> continue the processing for a specific type of error and to exit for
> some other types of errors.
>
> --
> __\/__
> / ^ ^ \
> (\| (o)(o) |/)
> --------------------------oOOOo--oo--oOOOo-------------------------------
> | Abiy Alemu | abiy_at_biotec.jouy.inra.fr |
> -------------------------------------------------------------------------
>
>

Look at the docs on the sqlca structure. See also the docs for the oraca structure. Also read the section on the use of WHENEVE SQLERREOR ... for implication on mixing the 2 styles.

--
Ron Reidy
Oracle DBA
Reidy Consulting, L.L.C. Received on Wed Jul 28 1999 - 06:37:38 CDT