9.4. Dependencies among Procedures

This section covers the following topics:

  • Editing and compiling a procedure that invalidates other procedures.

  • LAST_DDL_TIME and STATUS from USER_OBJECTS.

  • Compiling a schema with DBMS_UTILITY.COMPILE_SCHEMA.

  • Recompiling procedures, functions, and packages individually.

  • This section uses the script CHECK_PLSQL_OBJECTS from the previous section.

When we first compile the HELLO procedure, the CREATED time and LAST_DDL_TIME are identical.

OBJECT_NAME    STATUS  CREATED           LAST_DDL_TIME
-------------- ------- ----------------- -----------------
HELLO(P)       VALID   14-jul-2003 16:18 14-jul-2003 16:18

If we attempt to recompile the procedure and the compile fails, the procedure is still in the data dictionary but with an INVALID ...

Get Programming Oracle® Triggers and Stored Procedures, Third Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.