Recompile a stored stand-alone procedure.
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 Oracle Commands:
DBA_SOURCE ALL_SOURCE USER_SOURCE