Forum OpenACS Q&A: Response to sec_rotate_last_visit

Posted by Daryl Biberdorf on
drop & recreate is really the only way to modify stored procs in any rdbms...

Not, strictly speaking, true, since Oracle can do a CREATE OR REPLACE PROCEDURE x. The "OR REPLACE" is nice in that it preserves any permissions granted on the procedure.