Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_UTILITY , 2 of 23
This procedure compiles all procedures, functions, packages, and triggers in the specified schema. After calling this procedure, you should select from view ALL_OBJECTS
for items with status of INVALID
to see if all objects were successfully compiled.
To see the errors associated with INVALID
objects, you may use the Enterprise Manager command:
SHOW ERRORS <type> <schema>.<name>
DBMS_UTILITY.COMPILE_SCHEMA ( schema VARCHAR2);
Parameter | Description |
---|---|
schema |
Name of the schema. |
Exception | Description |
---|---|
ORA-20000 |
Insufficient privileges for some object in this schema. |
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|