Stop guessing how your Oracle application works. ODA collects source code from Oracle Forms, PL/SQL packages, and Reports into its own repository, parses every line, and builds a complete dependency graph. Navigate interactively object by object — or export a Technical Analysis Report so any developer can understand the business logic offline, even years after the original authors are gone.
ODA loads Oracle Forms, PL/SQL packages, and Reports into its repository and parses all code.
Every object reference — table, view, sequence, procedure — is indexed into a bidirectional dependency tree.
Explore dependencies live, pane by pane — click from object to object, see DML context, trigger code, and impact chains.
Generate a self-contained HTML document for offline analysis — for when the original authors have already retired.
● Interactive Visualization
Once ODA has built its repository, the full dependency graph is at your fingertips. Navigate from any object to everything connected to it — in both directions, across all platforms — through dedicated browser panes. No SQL queries, no manual tracing: just click and explore.
See "References" and "Referenced by" simultaneously. No more one-way dead ends — navigate upward and downward from any object, at any depth, instantly.
Drill into a form's triggers, blocks, and program units. See exactly which code touches which DB object — with the full code context shown inline, not just a name.
Know not just who uses a table — but how. A consolidated view of every SELECT, INSERT, UPDATE, DELETE per program unit, with the exact SQL statement, not just counts.
Refactor with confidence. Before altering any table or procedure, see every program unit that will be affected — before you change a single line of code.
What you see on screen
Object search returns every reference. Click any result to navigate directly into the code context.
FORM · PACKAGE · REPORTODA filters out 18 irrelevant units and shows the one that matters, with trigger and block path visible.
PACKAGE BODY · PL/SQLSee SELECT / INSERT / UPDATE / DELETE per unit, with the actual statement for each row.
DML ANALYSISEvery call site across every platform. Nothing gets missed, nothing gets left uncompiled.
IMPACT ANALYSIS● ODA Output — Technical Analysis Report
When the work needs to happen away from the tool — or needs to be handed to a developer who has never seen the codebase — ODA exports a complete Technical Analysis Report: a single, self-contained HTML file that maps the entire application. Open it anywhere, share it with anyone, read it on a plane.
ODA generates a structured, fully navigable HTML document — a complete map of your application. Every object, every relationship, every line of context that matters for understanding or migrating the system.
Planning to move your Oracle Forms to APEX? ODAUP is a dedicated APEX application that uses ODA's dependency engine to guide and manage the full migration — form by form, object by object.
More from SamTrest
Organize photo collections
Simplified email dispatch
Reports from SQL with parameters
Visual SELECT structure explorer
Track Oracle Forms requests
Step-through Forms execution
Split large PDFs into parts
Updates from the ODA team