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


© Copyright SS64.com 1999-2013
Some rights reserved