Re: Calling stored procedure in Forms
From: Ahmed Baraka <baraka_ahmed_at_hotmail.com>
Date: Wed, 11 Feb 2004 13:01:49 +0400
Message-ID: <c0cr2q$5vs3_at_news.emirates.net.ae>
Date: Wed, 11 Feb 2004 13:01:49 +0400
Message-ID: <c0cr2q$5vs3_at_news.emirates.net.ae>
To raise an exception in stored procedure use the following command: RAISE_APPLICATION_ERROR('error_message',<error_num>) error_num range between -20000 and 20999
In forms, you catch the raised error number using DBMS_ERROR_CODE and DBMS_ERROR_TEXT.
"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?
>
>
Received on Wed Feb 11 2004 - 10:01:49 CET