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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial