ALTER PROCEDURE
Recompile a stored stand-alone procedure.
Syntax:
ALTER PROCEDURE [schema.]procedure_name COMPILE [DEBUG] [REUSE SETTINGS];
REUSE SETTINGS will prevent Oracle from dropping and reacquiring compiler switch settings.
An alternative to ALTER PROCEDURE COMPILE is the built-in pl/sql package DBMS_UTILITY
I'm telling you, its a sick, sick nation that turned the word liberal into an expletive - Iain Banks (Dead Air)
Related Commands:
CREATE PROCEDURE
DROP PROCEDURE
Related Views:
CODE_PIECES
CODE_SIZE
DBA_SOURCE ALL_SOURCE USER_SOURCE
Equivalent SQL Server command:
