Home » SQL & PL/SQL » SQL & PL/SQL » cascade
cascade [message #260934] Tue, 21 August 2007 05:22 Go to next message
ikonindian
Messages: 5
Registered: April 2005
Location: Chennai
Junior Member
Hi ,

I need to alter the table which is being used by some of the packages. If I alter the table, the packages will go to Invalid status. So I have to find the dependencies, and recomplie those packages. Without doing these,

Is any way to compile those packages when at the time of giving alter statment to the table (like using cascade)..

Thanks in advance.

ikon
Re: cascade [message #260938 is a reply to message #260934] Tue, 21 August 2007 05:26 Go to previous messageGo to next message
sanka_yanka
Messages: 184
Registered: October 2005
Location: Kolkata
Senior Member

You didnot mention the oracle version.
If you are using the higher version i.e. 9i then you don't need to think about it.
Oracle automatically recompiles the invalid packages when it is called by the application if the status is invalid.

Cheers#
Sanka
Re: cascade [message #260939 is a reply to message #260934] Tue, 21 August 2007 05:26 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, but you don't need to recompile the package, Oracle will do it automatically the next time the package will be executed.

Regards
Michel
Previous Topic: create trigger on Sequence
Next Topic: Comparing comma seperated variable in IN clause
Goto Forum:
  


Current Time: Mon Dec 05 20:58:47 CST 2016

Total time taken to generate the page: 0.19735 seconds