Re: Package becomes INVALID when a partiiton is dropped
- From: Deepak Sharma <sharmakdeep_oracle@xxxxxxxxx>
- To: rjamya@xxxxxxxxx, listeric1@xxxxxxxxx
- Date: Wed, 29 Jun 2005 10:21:43 -0700 (PDT)
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@xxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
