Re: Using Packages makes ALTER TABLE dangerous

From: Frank <fbortel_at_nescape.net>
Date: Wed, 10 Dec 2003 22:52:07 +0100
Message-ID: <br841l$vtd$1@news2.tilbu1.nb.home.nl>

Joachim Zobel wrote:

> On Mon, 08 Dec 2003 22:43:28 +0100, Frank wrote:
>
>

>>No - there's a dependency between the package and the table. If one of
>>the dependants changes, the objects depending get invalidated.

>
>
> I know what _is_ happening. But this is not necessarily so. There could be
> for example compilation into versioned object files so that there is no
> need for locking against compilation.
>
>

>>And when using encapsulation, how can you alter the table? Surely this
>>should be solved withing the package...

>
>
> Huh?
>
> If you go from
>
> class foo {
> public:
> foo() {
> }
> private:
> int bar;
> }
>
> to
>
> class foo {
> public:
> foo() {
> bar = 0;
> }
> private:
> int bar;
> }
>
> there should be an interface?!
>
> Joachim
>

I fail to see what this has to do with PL/SQL and Oracle tables being dropped and recreated

-- 
Regards, Frank van Bortel

Received on Wed Dec 10 2003 - 15:52:07 CST