EXCEPTION : it's possibile obtain procedure and line ?

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 Fri Jul 17 1998 - 10:32:04 CDT