Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> catching exceptions in Pro*C thrown by stored procedures

catching exceptions in Pro*C thrown by stored procedures

From: paul cluiss <paul_cluiss_at_intervoice.com>
Date: Wed, 18 Aug 1999 15:55:33 -0500
Message-ID: <05546297E05B855C.6CD7AD0D27412518.9A83DEFEF653D9B4@lp.airnews.net>


Hello, everyone.

I have a Pro*C program which calls a stored procedure. Everything works great, but here's my problem: My stored procedure catches input data errors and throws exceptions, which I would like to catch inside my Pro*C program. Has anyone done this before? I've examined the Pro*C samples, and I found a few Pro*C programs which catch their own exceptions, but so far I've not found any examples of Pro*C programs which catch exceptions thrown from a stored procedure.

It may be easy, but I took a few stabs at getting the Pro*C syntax right and came up empty. Thanks for any help.

Paul Cluiss
Dallas, Texas Received on Wed Aug 18 1999 - 15:55:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US