Replaces an existing procedure with a modified version. Include the entire modified procedure in the ALTER PROCEDURE statement, and reassign user permissions on the procedure.
ALTER PROCEDURE [ owner.]procedure-name procedure-definition
CREATE PROCEDURE syntax following the name
The ALTER PROCEDURE statement is identical in syntax to the CREATE PROCEDURE statement.
Existing permissions on the procedure are maintained and need not be reassigned. If a DROP procedure and CREATE PROCEDURE were carried out, execute permissions would have to be reassigned.
Automatic commit is a side effect of this statement.
Must be the owner of the procedure or a DBA. Automatic commit.
