Re: Line numbers in PL/SQL

Speaking of development tools, I like PLEdit from benthic software. It's cheap

(about 30 USD) and it works quite well. take a look at www.benthicsoftware.com

There is a demo version that expires in 30 days or something.

David Fowler wrote:

> 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 - 21:22:15 CST