Re: Package becomes INVALID when a partiiton is dropped

From: Deepak Sharma <sharmakdeep_oracle_at_yahoo.com>
Date: Wed, 29 Jun 2005 10:21:43 -0700 (PDT)
Message-ID: <20050629172143.35882.qmail@web31202.mail.mud.yahoo.com>

Hi,

We modified the package so that it 'constructs' the record variable declaration to use the actual column datatype (e.g. COL1 VARCHAR2, COL2 NUMBER etc.), after dynamically getting column datatype from DD. It works now.

Thanks all,
Deepak

• rjamya <rjamya_at_gmail.com> wrote:

> IMHO Correct solution to this problem is NOT TO DROP
> the partition while to
> procedure is running. At the most you might need
> more space to hold the
> partition for couple of hours longer. But would you
> rather risk procedure
> getting (actually trying to get) invalid?
>
> Raj
>

---

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

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

Received on Wed Jun 29 2005 - 13:27:15 CDT