Re: DBMS_UTILITY.FORMAT_ERROR_BACKTRACE issue

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
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org