Re: Dependencies and invalidations.

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Sun, 23 Apr 2006 02:20:10 +0200
Message-ID: <e2eh7r$dsd$00$1@news.t-online.com>

Mladen Gogala schrieb:
> In Oracle RDBMS 10.2 it is practically impossible to invalidate a PL/SQL
> object. I tried with adding indexes, dropping primary key

Not every ddl invalidate the dependent procedures, only changing layout of tables ( i.e. add/drop/modify columns, maybe something else, but not add/drop constraint, alter table move etc.)

and analyzing
> the underlying tables,

Here you are joking - right ?

but the PL/SQL procedure build on top of the table
> remained valid. Oracle 9i PL/SQL objects were much more sensitive.

You probably don't have 9i instance right now to test, the behaviour is the same in 9i and even 8i.

Best regards

Maxim Received on Sat Apr 22 2006 - 19:20:10 CDT