Dependencies and References Viewer

The Dependencies and References Viewer enables you to view the dependencies and references that a database schema object has on other schema objects, both for Oracle Database connections as well as Oracle Database Project Version 2 projects. For example, if a stored procedure ADD_JOB_HISTORY performs a insert into database table JOB_HISTORY, then the Dependencies and References Viewer shows you that ADD_JOB_HISTORY has a dependency on JOB_HISTORY, while JOB_HISTORY is referenced by ADD_JOB_HISTORY.

Dependencies are displayed through a tree control where each node in the tree is a dependency of its parent node. When a node in the tree is selected, that object's references are displayed in the References portion of the viewer. Each tree node has a Sync with Explorer menu item which expands either the Server Explorer tree control or the Oracle Database Project Version 2 folder to highlight that object's location.

Opening the Dependencies and References Viewer

To open the Dependencies and References Viewer, right click on supported nodes in Server Explorer or on file names in an Oracle Database Version 2 Project and choose the Dependencies and References menu item.

Using the Dependencies and References Viewer

The Dependencies and References Viewer appears as follows:

Description of the illustration dependenciesreferences1.gif

The controls in the basic Dependencies and References Viewer are as follows:

Control	Description
Dependencies	Each node in the tree control is a dependency of its parent node. When a node in the tree is selected, that object's references are displayed in the References portion of the viewer. Each tree node has a Sync with Explorer menu item which expands either the Server Explorer tree control or the Oracle Database Project Version 2 folder to highlight that object's location.
References	This is a list of references for the item selected in the Dependencies tree control. Each reference has a Dependencies and References menu item which reloads the Dependencies and References Viewer to show the dependencies for that object.