ALTER PROCEDURE statement

Description

Replaces an existing procedure with a modified version. You must include the entire new procedure in the ALTER PROCEDURE statement, and reassign user permissions on the procedure.

Syntax

ALTER PROCEDURE [ owner.]procedure-name procedure-definition

Parameters

procedure-definition:

CREATE PROCEDURE syntax following the name

Usage

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.


Side effects

Automatic commit is a side effect of this statement.

Standards

Permissions

Must be the owner of the procedure or a DBA. Automatic commit.

See also

CREATE PROCEDURE statement