Re: EXCEPTION : it's possibile obtain procedure and line ?

in the code-depot on www.oracle-magazine.com is an article 'Catching Run-Time or User-Defined Errors'.
Maybe this can be of use.

Rene

Sbaiz wrote:

> Hi everyone
>
> In an EXCEPTION, is it possibile obtain (for example from SQLCA)
> the name of the procedure and/or the line where there is the problem?
>
> For example, if my procedure is:
>
> PROCEDURE get_imp IS
> BEGIN
>
> compute_users;
> compute_customers;
>
> EXCEPTION
> WHEN OTHER THEN
> err_line = SQLCA.get_line(); /*** it's an example ***/
> err_procedure = SQL.get.procedure()
>
> END
>
> then
> err_procedure = get_imp
> err_line = 83
> if the exception occour into get_imp procedure at line 83
> err_procedure = compute_users
> err_line = 323
> if the exception occour into compute_users at line 323
> and so on ...
>
> Thanks in advance
> Sbaiz P.
Received on Wed Jul 22 1998 - 01:58:22 CDT