Replaces a procedure with a modified version. You must include the entire new 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 except for the first word.
Existing permissions on the procedure are maintained, and do not have to 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 be DBA. Automatic commit.
