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>


"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
Received on Thu Feb 05 2004 - 15:23:25 CET

Original text of this message