Re: trapping pl/sql errors with line numbers

Ryan wrote:

> 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)
> >
> >

Not in production.

--
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)