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,Word files ...
The ODA is Java Swing application and requires Java Runtime Environment (JRE 1.6 version or higher).
For the Java version checking you run command java -version
For Oracle*Forms usage ODA requires Oracle Developer Suite installation.
Before the ODA installation you must create the ODA repository chema account in Oracle database.
The user repository owner must have "CREATE TABLE" and "CREATE SEQUENCE" and unlimited quota size permissions and to see DBA views.
Here's the user creating script:
-- Create the user
create user <Oda owner>
default tablespace USER
temporary tablespace TEMP
profile DEFAULT;
-- Grant/Revoke role privileges
grant connect to <Oda owner>;
grant resource to <Oda owner>;
grant select_catalog_role to <Oda owner>;
-- Grant/Revoke system privileges
grant select any table to <Oda owner>;
grant unlimited tablespace to <Oda owner>;

For the ODA starting you run command:
or In Login prompt you connect to Oracle user - owner of ODA repository(8 tables and 1 sequence).
At first time the ODA repository created automatically in Login ODA user schema(after prompt and confirmation). the ODA oprates with three Oracle schemas.

repository owner

DBA user

analyzed schema

At first time you must run at ODA with admin option for ODA repository creation. You connect to the ODA oracle user("repository owner") the schema where the ODA repository will be created,

A password is the oracle ODA user's password

Choose "OK" and the tool is ready for work.
The ODA running without admin mode is intended for check dependencies only. Admin mode allows objects data inserting and dependencies checking.
The repository owner can have any name.

First of all, you insert DB object metadata from a schema that you want to analyze("analyzed schema") and for the one you connect to DBA user("DBA user") with privilege "select dba_objects".

After, in "Administration>Insert objects" window,


you connect to "DBA user" and specify "analyzed schema" here.

In future you can drop or create new repository in Login window.

Insert objects into the ODA tables
• For work start you load objects by the buttons "Administration" -> "Insert object into repository" icon(top,right) or "Insert pattern word",
  • Oracle database objects. In the "Oracle DB" tab you populate database instance details you analyze.
    You can analyze some DB instances.
    In the login window you connect to user what has permissions to see analysed schemas objects.
    You must fill the "Adapter" field - ODA logical name of the DB connection and others jdbc parameters.
    We recommend an user with the DBA role or with select priveleges on DBA views (DBA_OBJECTS,ALL_SOURCE,PUBLIC_DEPENDENCIES,DBA_TRIGGERS...).
    The ODA does not change anything and does not create any object in the analysed database instances.
  • Forms
  • Reports
  • Flat or Word files
  • Pattern word for free search in PL/SQL codes
  • Metadata from Informatica server
  You press "Ok" for to add objects information into ODA repository.
• You are waiting to a populating process finished.
• There are two tabs "Reference" and "Referenced by".

A work started by two opportunities:

• 1.1 To put part or full object name in "Object search" item and choise at object in opened window.
• 1.2 To open tree folder by an object type, and to navigate to any object line.

For continue

• 2. To press the "Check object dependency"(the top button in vertical toolbar)
• 3. You can change an analyze direction by the "Exchange Parent/Detail" button(then bottom button in vertical toolbar).
• 4. You can continue to analyze subobject dependencies to navigate in the tree.
• 5. You can look the object details press the "Object browser" button at any time.
• 6. To use mouse double click on a interest word for the "Select object" window getting.

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.

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.
You can download Oracle Forms and Reports here

For Oracle forms download in Windows you can use something like:

set PATH=C:\Oracle\ids1012\bin;%PATH%
h:\my_projects\Java\jdk7_32\bin\java.exe -Xms256m -Xmx2048m -jar oda.jar admin

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.

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.

• Java Runtime Environment 1.6 or higher.
• If you want to explore Oracle*Forms application you must install Oracle developer suite

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.

For ODA running in Unix/Linux OS you must

• Use any graphical client
• Set current directory to ODA directory
• Set DISPLAY environment variable
• If you should analyze Oracle Forms/Reports you must install Oracle application server and set LD_LIBRARY_PATH environment variable
  export LD_LIBRARY_PATH=$ORACLE_HOME/lib

Probably, there isn't the correct Java version(the ODA needs JRE 1.6 version or higher).

If you use older Oracle forms suits (earlier than Forms 11) there's a Java version limitation. You can install java version 1.4 only.

For to solve this problem you download JRE 1.6 without full Java installation and you save it in any directory, c:\my_projects\jre6, for example.
After that you use these commands:

set JAVA_HOME= "c:\my_projects\jre6\"
set JAVA_EXE= "c:\my_projects\jre6\bin\javaw.exe"
%JAVA_EXE% -Xms512m -Xmx1200m -jar oda.jar admin

For a correct Oracle forms downloading you need to specify right encoding parameters.
%JAVA_EXE% -Xms512m -Xmx1200m -Dsun.jnu.encoding=Cp1255 -Dfile.encoding=ISO-8859-8 -jar oda.jar admin
(This example is right for hebrew)

The installation works correctly without any changes. It may be necessary to use the memory parameters, for example -ms2M -mx5M