#

| Appendix C Built-In Packages |

## C.4 DBMS_DDL

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);

### C.4.2 The ANALYZE_OBJECT procedure

A call to ANALYZE_OBJECT lets you programmatically compute statistics for the specified object. The specification is:

>     PROCEDURE DBMS_DDL.ANALYZE_OBJECT
>        (type VARCHAR2,
>         schema VARCHAR2,
>         name VARCHAR2,
>         method VARCHAR2,
>         estimate_rows NUMBER DEFAULT NULL,
>         estimate_percent NUMBER DEFAULT NULL);

C.3 Oracle AQ, the Advanced Queueing Facility |  | C.5 DBMS_ JOB

Copyright (c) 2000 O'Reilly & Associates. All rights reserved.