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?

"Johan Verlinden" <johan.verlinden (AT) iris (DOT) be> wrote

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

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 (DOT) be> wrote