Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.
NameOracle Forms PL/SQL Extractor
Latest version1.0 ( 1 April 2014 )
LicenseGNU LGPL 3
Issue tracker

Description / Features

This batch gives you the ability to extract PL/SQL source code from Oracle Forms. You can then feed SonarQube with the extracted PL/SQL source code.



This extractor uses the Oracle JDAPI library that is included in the Oracle Developer Suite. Therefore, a full installation of the Oracle Developer Suite is required. Once installed, check that the environment is correctly set:

  • The "PATH" environment variable must contain the Oracle Developer Suite paths, for example: PATH=C:/OracleDevSuite/jdk/jre/bin/classic;C:/OracleDevSuite/jdk/jre/bin;C:/OracleDevSuite/jdk/jre/bin/client;C:/OracleDevSuite/jlib;C:/OracleDevSuite/bin;C:/oraclexe/app/oracle/product/10.2.0/server/bin
  • The ORACLE_HOME "environment variable" must contain the Oracle root path, for example: ORACLE_HOME=C:/oraclexe/app/oracle/product/10.2.0/server


Running the extractor

Code Block
set FORMS_PATH=C:\forms_project java -DinputDir=C:\forms_project -DoutputDir=C:\extracted_plsql -cp C:\path\to\sonar-forms-plsql-extractor-1.0-jar-with-dependencies.jar;C:\path\to\oracle\forms\java\frmdapi.jar org.sonar.oracleforms.plsql.PlSqlExtractor

The Notes:

  • formsExtensions property


  • can also be set. It's a comma-separated list of


  • extensions of Oracle Forms files to extract.


  • Its default value is


  • fmb,mmb,olb,pll


  • .
  • The output directory, as set by the outputDir property


  • , must exist and is not


  • cleaned up. Generated files override existing ones.