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

From: <czekala_at_real.pl>
Date: Thu, 29 Jul 1999 14:28:12 GMT
Message-ID: <7npodi$lt8$1@nnrp1.deja.com>

Lets try via procedure with exeption statement

Rafal Czekala (czekala_at_real.pl)

In article <379D77A9.CEA30076_at_cril-ing.fr>, Abiy ALEMU <alemu_at_cril-ing.fr> wrote:
>
> --------------047F15588A8A76F4B3AF7B8A
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> 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  |

-
>
> --------------047F15588A8A76F4B3AF7B8A
> Content-Type: text/html; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> <HTML>
> I would like to make something like
> <BR>  EXEC SQL WHENEVER (SQLCODE = 6502) CONTINUE
>
> <P>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.
> <PRE>-- 
>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; __\/__

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; / ^&nbsp; ^ \

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp; (\| (o)(o) |/)

--------------------------oOOOo--oo--oOOOo------------------------------

-
>

|           &nbsp ;           Abiy

Alemu&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&
nbsp;&nbsp;

|           &nbsp ;           abiy_at_biotec.jouy.inra.fr  |
>

-</PRE>
>  </HTML>
>
> --------------047F15588A8A76F4B3AF7B8A--
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Jul 29 1999 - 09:28:12 CDT