Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
NameOracle Forms PL/SQL Extractor
Latest version1.0 ( 1 April 2014 )
DownloadTODO
LicenseGNU LGPL 3
DevelopersSonarSource
Issue trackerhttp://jira.codehaus.org/browse/SONARPLUGINS/component/16261
Sourceshttps://github.com/SonarCommunity/sonar-forms-plsql-extractor

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.

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/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
languagetext
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.