# Features

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.

# Usage

### Prerequisites

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;C:/oraclexe/app/oracle/product/10.2.0/server/bin
• The "ORACLE_HOME" environment variable must define the absolute path to Oracle installation, for example: ORACLE_HOME=C:/oraclexe/app/oracle/product/10.2.0/server

### Extract PL/SQL Codebase

 set FORMS_PATH=C:\forms_project java -DinputDir=C:\forms_project -DoutputDir=C:\extracted_plsql -cp C:\path\to\sonar-forms-plsql-extractor-1.1-jar-with-dependencies.jar;C:\path\to\oracle\forms\java\frmjdapi.jar org.sonar.oracleforms.plsql.PlSqlExtractor
• 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.