ODA FAQ


ODA and stored procedures.

ODA can search and show dependences 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 dependences 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 pivileges for ODA running

The user (ODA repository owner), in schema of which is constructed ODA repository(~7 tables), it is understandable, he must have a privilege of the creation of tables and sequences. If we speak about the system privileges, then user must see DBA views which is reached with the aid of privilege SELECT_CATALOG_ROLE, for this it is not necessary to be DBA.
ODA uses DBA views (DBA_OBJECTS,PUBLIC_DEPENDENCY,DBA_SOURCE) and for this ODA repoisitory owner requires SELECT grants.

Does ODA search objects dependences in Oracle Forms 6i/10g?

Yes. ODA seeks dependencies in Forms triggers, properties and program units.