Ispirer Ispirer

How to: collect metrics on Oracle Forms/Reports/Menus/Libraries

To collect metrics on Oracle Forms/Reports/Menus/Libraries you can use the method below:

First, extract all Oracle objects from BINARY format to XML:

  • Oracle Forms (*.fmb) → *.xml
  • Oracle Menus (*.mmb) → *.xml
  • Oracle Reports (*.rdf) → *.xml
  • Oracle Libraries (*.pll)→ *.pld

For more information on extracting Oracle objects, please see this article

You can also use the scripts that we’ve created specifically for our customers. These scripts should be run on the PC where Oracle is installed.

After that, all Oracle Forms should be placed to C:\Forms\ (*.fmb);

All Oracle Menus should be placed to C:\Menus\ (*.mmb) ;

All Oracle Reports should be placed to C:\ Reports\ (*.rdf);

All Oracle Libraries should be placed to C:\ pll\ (*.pll)

Then run CMD from your Oracle BIN directory (ex., C:\oracle\ora92\bin\) so that the command batches could appear:

  • f2xml.bat – to extract FORMS
  • pll2xml.bat – to extract LIBRARIES
  • r2xml.bat – to extract REPORTS
  • m2xml.bat – to extract MENUS

After all XML have been extracted, you can count the number of lines of code for every object type. To count the number of LOC you can use this free toolkit or you can use regular expressions in Visual Studio.

sqlways/oracle-forms/collect-metrics-on-oracle-forms.txt · Last modified: May 07, 2018, 03:15:36 PM (external edit)
© 1999-2019, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement