Table of Contents
Ispirer Website
Ispirer Capabilities - Oracle Forms Conversion
Free Trial
Oracle Forms Conversion
When we need to assess the Oracle Forms application code, first we should know the number of lines of code for every type of files. For counting lines we need extract binary files (fmb forms ,mmb - menus, olb - objects, pll - libraries, rdf - reports) to XML/PLD format:
Converting FormModules, ObjectLibraries, or MenuModules to XML
You can convert Oracle Forms FormModule, MenuModule, and ObjectLibrary files to Extensible Markup Language (XML) using the Oracle Forms to XML conversion tool, Forms2XML. The Oracle Forms to XML conversion tool, Forms2XML was introduced in Oracle9i Oracle Developer Suite and is also available in Oracle Developer Suite 10g. This tool should also work on files from earlier releases of Oracle Forms. If the Oracle Forms to XML Conversion tool does not work for a specific file from an earlier version of Oracle Forms then that file will must be upgraded to Oracle Developer Suite 9i or 10g and then converted to XML Forms2XML produces an XML file that has the same base name as the Forms file with a .xml extension. The extension _fmb, _mmb, or _olb is added to the base file name to indicate whether the original file was a Forms Modules, a MenuModule, or an Object Library. The following table displays a few examples of the changes the tool makes to the name of the file being converted:
| File name before conversion | File name after conversion |
|---|---|
| myForm.fmb | myForm_fmb.xml |
| myMenu.mmb | myMenu_mmb.xml |
| myLibrary.olb | myLibrary_olb.xml |
The Forms2XML command takes one or more Forms Module files as an argument. The files can be FormsModule (.fmb), ObjectLibrary (.olb), or MenuModule (.mmb) files. The output is placed in the current folder. The command has the following syntax:
frmf2xml [options] file1 [file2…] java oracle.forms.util.xmltools.Forms2XML [options] file1 [file2…]
Available options include:
| Options | Description |
|---|---|
| USE_PROPERTY_IDS=YES/NO | Setting USE_PROPERTY_IDS to YES causes the Forms to XML conversion tool to write the internal ID for Real or Character into the XML file. The default value (NO) generates property value names as before. Note: The Forms2XML utility must be run with USE_PROPERTY_IDS=NO. |
| OVERWRITE=YES/NO | Valid values are YES or NO. If OVERWRITE=YES, the tool overwrites any XML files with the same name that already exist in the output directory. If OVERWRITE=NO, (default) the tool does not overwrite any XML files with the same name that already exist in the output directory. The tool will stop processing and return the message: If the file file already exists. Use argument OVERWRITE=YES to replace. |
| DUMP=ALL/OVERRIDEN | If DUMP=ALL, the tool dumps all properties. If DUMP=OVERRIDEN, the tool dumps only those properties that are overriden. |
Converting a PL/SQL Library
To convert a PL/SQL library, use the File > Convert option in Oracle Forms Builder to convert PL/SQL library .PLL files to .PLD text files.
For extracting of PLL:
Step1
Step2
Converting an Oracle Report to XML
To convert an Oracle Report, use the File Conversion option in Reports Builder to convert binary (.RDF), ASCII (.REX), and .JSP reports to XML format.
For extracting of RDF:
Step1
Step2
Note: you can choose multiple files for conversion using Browse.
Please refer to the article for detail information:
http://docs.oracle.com/cd/E14373_01/migrate.32/e13368/appmgr_forms.htm#insertedID2
When you extract XML and count the LOCs (you can use this free toolkit http://cloc.sourceforge.net/), please send us this information about your application and we can provide you the rough estimations for your migration project.
Thanks!