|Name||Oracle Forms PL/SQL Extractor|
|Latest version||1.1 (14 May 2014)|
|License||GNU LGPL 3|
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:
formsExtensionsproperty can also be set. It's a comma-separated list of extensions of Oracle Forms files to extract. Its default value is
- The output directory, as set by the
outputDirproperty, 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.