RE: Package becomes INVALID when a partiiton is dropped
- From: Deepak Sharma <sharmakdeep_oracle@xxxxxxxxx>
- To: Thomas.Mercadante@xxxxxxxxxxxxxxxxx, Eric List <listeric1@xxxxxxxxx>
- Date: Tue, 28 Jun 2005 11:23:37 -0700 (PDT)
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@xxxxxxxxxxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
