ODA is the tool for analyse of object dependency in any Oracle database application.
Any relation (object dependency) is shown by ODA with a code's fragment where it used.

With ODA you can receive a report on all object dependencies with their contexts, a code of the program with the allocated dependency and dependencies tree.

ODA can to find object dependencies in two modes of Oracle usage:

• Database server: You can work with object dependencies of Oracle database (stored procedures, tables, views, sequencies)
• Client: You can analyse in addition to the first mode also dependencies between Oracle*Forms and Oracle objects, to see also relations of forms in application, global variables and parameters usage, forms structure (blocks, properties, triggers, program units ) and statistic;

Software requirements:

Java Runtime Environment

Usage:

  java -Xms32m -Xmx512m -cp .\classes12.jar;.\frmjdapi.jar;.\oda.jar; jao.Main