Re: error trapping in PL/SQL packages
From: Maur�cio Bellissimo Falleiros <mbf_at_uniconsult.com.br>
Date: Mon, 04 Oct 1999 12:35:55 -0300
Message-ID: <37F8C95B.3A279809_at_uniconsult.com.br>
Date: Mon, 04 Oct 1999 12:35:55 -0300
Message-ID: <37F8C95B.3A279809_at_uniconsult.com.br>
Hi Sammy,
raise_application_error has an optional boolean parameter (defaults to
false),
that, when set to true, stacks the error raise, instead of overriding
the previous ones.
Then, you can use dbms_util.format_error_stack (no parameters, returns
varchar2).
In Forms, you can use the dbms_error_text function, instead.
Hope this helps,
Maur�cio.
-- Maur�cio Bellissimo Falleiros <mailto:mbf_at_uniconsult.com.br> Uniconsult Sistemas e Servi�os <mailto:uss_at_uniconsult.com.br> R. Dem�stenes, 627 cj.134/142 - Campo Belo - S�o Paulo/SP - 04614-013 Brasil Fone/Fax: +55-11-5350885 +55-11-5333335 "Em um minuto apenas h� tempo Para decis�es e revis�es que um minuto revoga." T.S.Eliot * Sent from RemarQ http://www.remarq.com * The Internet's Discussion Network * * The fastest and easiest way to search and participate in Usenet - Free! *Received on Mon Oct 04 1999 - 17:35:55 CEST