Oracle Database Administration: The Essential Refe

Name

ALTER PROCEDURE

Synopsis

ALTER PROCEDURE
[schema.]procedure_name
COMPILE

Recompiles a standalone stored procedure ( procedure_name). The COMPILE keyword is required.

Notes

This command first recompiles all objects upon which this procedure depends; if any of those objects are invalid, the procedure being recompiled will also be marked invalid. The procedure must be in your schema or you must have the ALTER ANY PROCEDURE privilege to issue this command.

Example

The following example explicitly recompiles the procedure called midday in schema scott:

ALTER PROCEDURE scott.midday COMPILE