Re: Tracing query inside procedure without 10046

It would probably have been a good idea to include the URL in the previous email: Line Numbers | Oracle Scratchpad (wordpress.com) <https://jonathanlewis.wordpress.com/2014/11/28/line-numbers/>

Regards
Jonathan Lewis

On Fri, 4 Aug 2023 at 16:06, Jonathan Lewis <jlewisoracle_at_gmail.com> wrote:

>
> David,
>
> Coincidentally I rediscovered this blog note a few minutes ago - which may
> be the problem I was thinking of, and may not be the same problem to the
> hierarchical profiler. I've just tested on 23c and I changing the
> plsql_optimize_level changes the line number reported by the call to
> calculate ln(-1), and the default setting is the one where the reported
> line number doesn't match user_source.
>
> Regards
> Jonathan Lewis
>
>
>
>
> On Fri, 4 Aug 2023 at 14:15, David Kurtz <info_at_go-faster.co.uk> wrote:
>
>> I haven't observed that, but I have only used the hierarchical profiler
>> in 19c. It has always matched up for me.
>>
>> And, of course, you wave to unwrap and save procedures to see them in
>> user_source. Doing so doesn't seem to affect the line numbers.
>>
>>
>>
>> David Kurtz
>> Go-Faster Consultancy
>> www.go-faster.co.uk
>> Tel: +44 7771 760660
>> (sent from a mobile device, typos and brevity to be expected)
>>
>>>
>>>>>>

--
http://www.freelists.org/webpage/oracle-l