Re: Package becomes INVALID when a partiiton is dropped

The kernel is likely taking a ddl lock and updating DD for the table and partition when the partition is dropped.

This would invalidate the procedure.

I have not built a test case, I have left that for you. :)

Jared

PS. Check the LAST_DDL_TIME column in the DBA_OBJECTS view

On 6/27/05, Deepak Sharma <sharmakdeep_oracle_at_yahoo.com> wrote:
>
> I have a table, say T1, having 3 partitions P1, P2 and
> P3.
>
> There exists a PL/SQL procedure that declares
> variables as :
>
> col1 T1.col1%TYPE
>
> When I drop a partition P1 of table T1, the PL/SQL
> procedure becomes INVALID.
>
> The PL/SQL doesn't reference the partition P1 at all.
>
>
>
> ____________________________________________________
> Yahoo! Sports
> Rekindle the Rivalries. Sign up for Fantasy Football
> http://football.fantasysports.yahoo.com
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l