Implement CREATE OR REPLACE option for stored procedures
We are looking to deploy more code into the system hot, taking advantage of improvements have made to trap any -710 errors internally and re-parse transparent to the user session.
Currently it is necessary to drop a procedure before creating a new one. This leaves a short window in which no procedure is in place.
By implementing a CREATE OR REPLACE option, a version of the stored procedure could always be available. To be useful this would have to be implemented in such a way that there is no possibility of sessions trying to access the procedure in between the DROP and CREATE and getting an SQL error.
It would also be a useful convenience feature.
British Sky Broadcasting