Package becomes INVALID when a partiiton is dropped

From: Deepak Sharma <sharmakdeep_oracle_at_yahoo.com>
Date: Mon, 27 Jun 2005 14:00:59 -0700 (PDT)
Message-ID: <20050627210059.51694.qmail@web31201.mail.mud.yahoo.com>

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

Received on Mon Jun 27 2005 - 17:06:21 CDT