Although there are a lot of postings regarding debugging, I couldn't
find information about the best way to debug a package. I tried the
debugger that comes with SQL Developer, but I think this tool is only
capable of debugging procedures that are not part of a package.
Any ideas about the best approach to debug a package?
FYI: I work with Oracle 8.1.7

Thanks.

Peter

VDK wrote:
possibly to debug about a package?!?
Right - nothing.

Only the procedures and functions contained in that
gift wrap paper Oracle calls a package ought to be
debugged.

SQL Developer has a very nice debugger, although I like
the one with PL/SQL Developer (by Allroundautomation)
best. TOAD would be a good third, and I have no need for
more.
--
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

VDK wrote:
You are in an Paleolithic unsupported version of Oracle: Don't expect much.

Frank ... One can write a ton of code into a package that is not part
of either a procedure or a function. Remember the initialization section.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

DA Morgan wrote:
I know, I know - I regularly remind people it can be used
to establish standards that way.

But what is there to debug about an initialization section?

Maybe for some, reading carefully is debugging. In that case,
I concur.

--
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

On Fri, 12 Oct 2007 03:17:14 -0700, VDK <peter.vanderkamp (AT) wur (DOT) nl>
wrote:

Just to add something. In Oracle 9i, the debugger does work on
PACKAGEs, but must be executed from the PACKAGE, not the PACKAGE BODY.
I wonder if this applies to Oracle 8i.

B.

On Fri, 12 Oct 2007 19:24:33 +0200, Frank van Bortel
<frank.van.bortel (AT) gmail (DOT) com> wrote:

I also preferred PL/SQL Developer. But that was when the company was
willing to pay for it. For me for myself, it's just way too
expensive.

B.