dbms_ddl.alter_compile procedure alter_compile(type varchar2, schema varchar2, name varchar2); -- Equivalent to SQL "ALTER PROCEDURE|FUNCTION|PACKAGE [<schema>.] -- <name> COMPILE [BODY]". If the named object is this package, -- or any packages upon which it depends (currently "standard" or -- "dbms_standard") then the procedure simply returns (since these -- packages are clearly successfully compiled). -- Input arguments: -- type -- Must be one of "PROCEDURE", "FUNCTION", "PACKAGE", "PACKAGE -- BODY" or "TRIGGER". -- schema -- The schema name. If NULL then use current schema. Case sensitive. -- name -- The name of the object. Case sensitive. -- Exceptions: -- ORA-20000: Insufficient privileges or object does not exist. -- ORA-20001: Remote object, cannot compile. -- ORA-20002: Bad value for object type. Should be one of PACKAGE, -- PACKAGE BODY, PROCEDURE, FUNCTION, or TRIGGER.
-- Equivalent to SQL "ALTER PROCEDURE|FUNCTION|PACKAGE [<schema>.]
-- <name> COMPILE [BODY]". If the named object is this package,
-- or any packages upon which it depends (currently "standard" or
-- "dbms_standard") then the procedure simply returns (since these
-- packages are clearly successfully compiled).
-- Input arguments:
-- type
-- Must be one of "PROCEDURE", "FUNCTION", "PACKAGE", "PACKAGE
-- BODY" or "TRIGGER".
-- schema
-- The schema name. If NULL then use current schema. Case sensitive.
-- name
-- The name of the object. Case sensitive.
-- Exceptions:
-- ORA-20000: Insufficient privileges or object does not exist.
-- ORA-20001: Remote object, cannot compile.
-- ORA-20002: Bad value for object type. Should be one of PACKAGE,
-- PACKAGE BODY, PROCEDURE, FUNCTION, or TRIGGER.