C.4 DBMS_DDL

Appendix C
Built-In Packages

 

---

The DBMS_DDL package provides access to some of the SQL DDL statements from within stored procedures.

C.4.1 The ALTER_COMPILE procedure

The ALTER_COMPILE procedure can be used to programmatically force a recompile of a stored object. The specification is:

PROCEDURE DBMS_DDL.ALTER_COMPILE    (type VARCHAR2,     schema VARCHAR2,     name VARCHAR2);