ZPA Forms Extractor 1.0.0
· One min read
ZPA Forms Extractor 1.0.0 is out! It is a new tool that brings the PL/SQL code of Oracle Forms within reach of ZPA.
Forms keeps its code inside binary modules (.fmb, .mmb, .pll, .olb). The extractor opens them through Oracle's
Forms API and writes:
- every trigger, program unit, menu item and record group query to its own file, as compilable PL/SQL;
- a
metadata.jsonwith the blocks, items, alerts and LOVs of each form, ready to be used as ZPA's Forms metadata.
zpa-forms-extractor --input forms/ --output extracted/ --metadata-format legacy
zpa-cli --sources extracted/orders.fmb --forms-metadata extracted/orders.fmb/metadata.json
The extractor runs on a machine with Oracle Forms Builder installed and needs Java 8 or newer. With ZPA 4.2.1, use
--metadata-format legacy.
See Oracle Forms support for the complete workflow with the ZPA CLI and the SonarQube plugin, and the project README for installation and troubleshooting. The tool is open source under the Apache License 2.0.
Download it from the release page.