MANAGING DEPENDENCIES IN ORACLE

MANAGING DEPENDENCY WITH PACKAGED SUBPROGRAM

In this article we will check how dependency works with packaged subprogram.

First, we will create a package and then we will call the packaged subprogram through a stand alone procedure.

CREATE OR REPLACE PACKAGE 

IMPACT OF CHANGING REFERENCED OBJECT ON PROCEDURE

If we add any column to the table which is used in a stored procedure then the procedure gets invalidated. But Oracle automatically compiled the invalid object when it is called for execution.

CREATE 

IMPACT OF CHANGING REFERENCED OBJECT ON FUNCTIONS

If we add any column to the table which is used in a stored function then the function get invalidated. But Oracle automatically compiled the invalid object when it is called for execution.…

IMPACT OF CHANGING REFERENCED OBJECT ON VIEW

Prior 11g, if we add any column to the base table of a view then the view got invalidated. From 11g onward this problem has been fixed. Oracle automatically compiled the invalid object …

MANAGING DEPENDENCIES IN ORACLE

WHAT IS DEPENDENCY?

If the definition of object OB1 references object OB2 then OB1 is dependent on OB2. Oracle database automatically track and manages these dependencies. If you alter the definition of reference object OB2 then …