Re: Package debugging
From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sun, 14 Oct 2007 14:43:43 +0200
Message-ID: <fet2tt$he8$1_at_news5.zwoll1.ov.home.nl>
>> 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
Date: Sun, 14 Oct 2007 14:43:43 +0200
Message-ID: <fet2tt$he8$1_at_news5.zwoll1.ov.home.nl>
DA Morgan wrote:
> VDK wrote:
>> 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
> > 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.
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...Received on Sun Oct 14 2007 - 14:43:43 CEST