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.