Strategy for publishing SPs on live server?

From: <skrul_at_yahoo.com>
Date: Wed, 01 Dec 1999 17:30:22 GMT
Message-ID: <823lvf$l6s$1@nnrp1.deja.com>

Hey all --

I am new to Oracle development (from SQL Server) and one problem I keep having is when I update a stored procedure on the live server, it invalidates other SPs that depend on it. Is there a good strategy to go about doing this? It is hard to try to recompile the dependant procedures by hand, since there could be many and I may not be fast enough!

Thanks for any advice,
-steve

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Dec 01 1999 - 11:30:22 CST