Re: DBMS_UTILITY.FORMAT_ERROR_BACKTRACE issue

On May 1, 10:23 am, DA Morgan <damor..._at_psoug.org> wrote:
> Ziad wrote:
> > Hi,
> > I'm using 10g, and having a problem with backtrace when it comes to
> > giving me the correct line number where the error happened. The
> > problem seems to be related to for loop cursors.
>
> It is the result of the fact that Oracle knows when it found the issue
> not necessarily where it exists.
>
> For example:
>
> SELECT 'this || is'' || a potential problem'
> FROM dual;
>
> well actually it isn't as it is syntactically correct.
>
> But one might well argue that it should have/could have been
> intended to be something else. It is just the nature of the beast.
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

Can I quote you on that? :)

David Fitzjarrell Received on Tue May 01 2007 - 11:07:52 CDT