RE: Package becomes INVALID when a partiiton is dropped

From: Deepak Sharma <sharmakdeep_oracle_at_yahoo.com>
Date: Tue, 28 Jun 2005 11:23:37 -0700 (PDT)
Message-ID: <20050628182337.89073.qmail@web31215.mail.mud.yahoo.com>

Tom,

The package (actually one of the procedures witing it) references the table (T1) in variable declarations:

Example:

declare

   col1 T1.col1%TYPE;
begin
...
end;
/

How would we do the declaration dynamically? Am I missing something?

Thanks,
Deepak

• "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante_at_labor.state.ny.us> wrote:

> Deepak,
>
> Something else you can do. Change your package so
> that it does not
> *directly* depend on the table. You could use
> dynamic SQL to perform
> your queries against the table. This way, Oracle
> does not know that the
> package is related to the table and will not mark it
> as invalid.
>
> Tom
>
                

---

Do you Yahoo!?
Yahoo! Mail - Find what you need with new enhanced search. http://info.mail.yahoo.com/mail_250

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

Received on Tue Jun 28 2005 - 14:29:07 CDT