Skip to end of metadata
Go to start of metadata


This command-line gives 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/jlib;C:/OracleDevSuite/bin;

Use Java 1.6 or higher to run Sonar Forms PLSQL Extractor.

Extract PL/SQL Codebase

Download the extractor JAR file (see link in the top of this page) then execute:


  • 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.


Q : I'm getting "Exception in thread "main" java.lang.NoClassDefFoundError: Could not initialize class oracle.forms.jdapi.Jdapi" whilst my env variables and paths are correctly configured, why ?

A :  Oracle Developer Suite used to perform the extraction is available only for x32 OS. As a consequence, the Oracle Forms PL/SQL Extractor will work only on x32 OS.


  • No labels