Re: Calling stored procedure in Forms
From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Thu, 5 Feb 2004 09:23:25 -0500
Message-ID: <NJidnYBeqOOaz7_dRVn-jA_at_comcast.com>
Date: Thu, 5 Feb 2004 09:23:25 -0500
Message-ID: <NJidnYBeqOOaz7_dRVn-jA_at_comcast.com>
"Johan Verlinden" <johan.verlinden_at_iris.be> wrote in message
news:40224c6f$0$13254$ba620e4c_at_news.skynet.be...
| We are using Forms6i with a Orcake8i database.
| We call a stored procedure from within our trigger code. Can anyone tell
me
| how I have to handle possible exceptions happening in the procedure on the
| server side. Can we catch exceptions occuring on the server in our trigger
| code?
|
|
any exception not handled by any PL/SQL block (ie, the stored procedure) is propagated to the calling environment (ie, Forms 6i) and can be handled with standard PL/SQL exception handling
so, this should be a piece of 'Orcake' ;-)
- mcs