Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: trapping pl/sql errors with line numbers
you might be able to grab the line numbers with dbms_debug? dont know for
sure though.
"Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message
news:3EF1DA00.DB9D251F_at_exxesolutions.com...
> Jeff Smith wrote:
>
> > I have been searching docs and sites but no luck.
> >
> > When catching unhandled errors in PL/SQL procedures using 8.1.7, is
there
> > any internal function that can record the line number that failed?
> >
> > If caught in an WHEN OTHERS THEN exception block, we record the SQLCODE,
but
> > it would be nice to know what line failed. Having the line from
all_source
> > would make it easier to debug.
> >
> > Regards,
> > Jeff
>
> No. But you can put a variable at the beginning of each block identifying
the
> block in which the
> failure occured and then write it as part of the message to the error
logging
> table.
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
>
Received on Thu Jun 19 2003 - 15:59:29 CDT