ODA home
     


ODA FAQ

First steps.

The ODA tool analyzes oracle database object dependencies in PL/SQL code, forms and reports code and properties.
ODA can check object dependencies in flat files, C files, XML files, scripts ...
The ODA is Java Swing application and requires Java Runtime Environment (JRE 1.6 Version and higher) .
For the ODA tool start you run command:
java -Xms32m -Xmx512m -cp classes12.jar;frmjdapi.jar;oda.jar jao.Main admin for Windows
java -Xms32m -Xmx512m -cp classes12.jar:frmjdapi.jar:oda.jar jao.Main admin for Unix/Linux

In Login prompt you connect to Oracle user - owner of ODA repository(~5 tables and 1 sequence).
At first time the ODA repository created automatically in Login ODA user schema. In future you can drop or create new repository in Login window.
ODA user must have privileges CREATE TABLES/SEQUENCE.
You can load object by the buttons "Administration" -> "Insert object into repository" or "Insert pattern word", insert into ODA repository any object types : You press "Ok" for to add objects information into ODA repository.
You choose the object type in "Add object" window.
For add database object information you connect to the analyzed database with oracle user what can show all interested database objects. The ODA application select information in this database only.
You press "Check object dependency" button for to look the object's dependencies. You can look object dependencies in both directions ("Parent" and "Detail" tabs). For offline analyzing it is possible to receive a report by the button "Object dependency report".

ODA presentation structure.

To see a object dependency you need to press "Check object dependencies" button an after to use mouse double click(or click at "+").
A "Parent" tab shows the dependencies of objects referenced in the tree line object.
A "Detail" tab shows the objects where the tree line object used.

ODA and Oracle*Forms/PLL/Reports.

The ODA seeks dependencies in Forms/Reports triggers, block and item properties,parameters,report queries and program units. In the beginning to load ("Insert object into repository" button, "Oracle DB" tab) in ODA repository all DB objects. You should try to load all Oracle schemas which Form application works against.
For correct Form upload process Oracle Developer Suite must be installed.

For the Form/PLL/Report upload ("Insert object into repository" button, "Form"/"Report" tab) - you can choose form file path; when you choose directory then all files of directory will be loaded.
For Oracle modules download in Unix/Linux OS, you must set
export LD_LIBRARY_PATH=$ORACLE_HOME/lib

ODA and stored procedures.

ODA can search and show dependencies looking at the objects those locating in Oracle schema and for this uses only dba_objects, public_dependency, dba_source system views.
ODA supplements the dependencies between the objects with the context of using - shows the program code, where table or procedure is used. Packages in this case are parsed to the procedures and the functions. Therefore you obtain the fragment of the code with the indication of the name of the specific procedure of package.

ODA requirement.

Oracle connects for the ODA usage

For to logon into ODA application you connect to the ODA user what ODA repository owner.

For to add into ODA application all objects of analyzed database you connect to any oracle user can look these objects.

ODA running in Unix/Linux OS

For ODA running in Unix/Linux OS you must