Re: Line numbers in PL/SQL

Clemens,
  The package body. Try select * from user_source where object_type ='PACKAGE BODY' and object_name = 'YOUR_PACKAGE_NAME' order by line_num. I believe. To get the exact columns just select * from user_source.

I would get a development tool to make your life easier. TOAD for cheap www.quest.com
SQL Navigator if serious development of package etc required. hth
Dave Fowler

"Clemens Hoffmann" <choffmann_at_heeg.de> wrote in message news:96ipe1$2n6$1_at_charly.heeg.de...
> "Sean" <dolans_at_my-deja.com> schrieb im Newsbeitrag
> news:961gts$g73$1_at_nnrp1.deja.com...
> > Platform: Oracle 8.1.7 on NT 2000
> >
> > When you get an ORA error from a PL/SQL package and it says it occurred
> > on "line 375", from where in the package does it start? Does it
> > include the package declaration as part of the line count or does it
> > start within the body and count down from there?
> >
> > Is there a "quick" way to see the line at which the procedure is dying?
>
> Hi Sean,
>
> a pretty dirty but usefull way to get the numbers is to
> save them while installing the package
>
> set spool <some file name>
> set echo on
>
> -- install the package
>
> set spool off
> set echo off
>
> This will save the package code together with the line
> numbers to a file.
>
> Later you can load it into a word processor and view
> or print it when searching the error
>
> Greetings
>
> Clemens Hoffmann
>
>
>
Received on Sun Feb 18 2001 - 20:51:41 CST