Home » SQL & PL/SQL » SQL & PL/SQL » cascade
cascade [message #260934] Tue, 21 August 2007 05:22 Go to next message
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.

Re: cascade [message #260938 is a reply to message #260934] Tue, 21 August 2007 05:26 Go to previous messageGo to next message
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.

Re: cascade [message #260939 is a reply to message #260934] Tue, 21 August 2007 05:26 Go to previous message
Michel Cadot
Messages: 64948
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.

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

Current Time: Fri Jun 23 05:35:36 CDT 2017

Total time taken to generate the page: 0.20955 seconds