Re: How to make SP valid?

> Hello,
> I have an PL/SQL stored procedure which uses table T1.
> My application drops this table and create another one, different table, but
> with the same name T1.
> In the moment my stored procedure become invalid, because table T1 was
> dropped.
> How could I make the stored procedure valid after table T1 recreation, using
> SQL statements?
> Thanks,
> Gennady

Is it really important to drop the table? Will TRUNCATE do the same for you?

If you need to drop and rebuild the table T1 then you can/have to recompile the package

alter package <your package> compile;

Regards, Stephan

--
---------------------------------------------------------------
Dipl.-Inf. (FH) Stephan Born   | beusen Consulting GmbH
fon: +49 30 549932-0           | Landsberger Allee 392
fax: +49 30 549932-21          | 12681 Berlin
mailto:stephan.born_at_beusen.de  | Germany
---------------------------------------------------------------
       PGP-Key verfügbar       |      PGP-Key available
---------------------------------------------------------------