Re: dbms_output package
Date: 1996/02/21
Message-ID: <4gg8mm$rbn_at_thymaster.interaccess.com>#1/1
W.van.der.Deijl_at_inter.nl.net (Wilfred van der Deijl) writes:
>Sudarshan N Murty <smurty_at_fpk.novell.com> wrote:
>>Oracle gurus,
>Well if you want to call me that, go ahead :-)
>> In PL/SQL when I use dbms_output.put_line() to debug stored
>>procedures, the line #/col # never seems to match up with the line
>>numbers in the text. I tried filtering out all the blank lines in the
>>source file with no success. What am I missing here ?
>>Any help is greatly appreciated.
>i guess the best thing is to query the USER_SOURCE (or ALL_SOURCE)
>view and get the line-number from this view. I think (but do not know
>for sure) that this is the exact line number that Oracle reports.
>Bye,
>Wilfred
>The Netherlands
>E-mail : W.van.der.Deijl_at_inter.nl.net
>Homepage: http://www.inter.nl.net/users/W.van.der.Deijl
> (including the MicroProse Grand Prix II FAQ!)
Good suggestion, Wilfred. Note that this is for objects stored within the
database (packages, etc.) only.
Another reason that your line numbers might not match up is if you use
comments in your source code. For Oracle, "line 1" is the first
non-commented (or blank) line in the source code.
Hope this helps...
-Ari Kaplan
E-mail : akaplan_at_interaccess.com
Homepage : http://homepage.interaccess.com/~akaplan
Received on Wed Feb 21 1996 - 00:00:00 CET