Skip to content
main
Switch branches/tags
Code

Latest commit

 

Git stats

Files

Permalink
Failed to load latest commit information.
Type
Name
Latest commit message
Commit time
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

ZPA CLI

Build Status

This is a command-line interface to the Z PL/SQL Analyzer. It is a code analyzer for Oracle PL/SQL and Oracle Forms projects.

Downloading

Official releases are available for download on the "Releases" page.

Requirements

  • Java 11 or newer

Usage

Currently, the zpa-cli supports these options:

  • --sources: [required] Path to the folder containing the files to be analyzed.
  • --forms-metadata: Path to the Oracle Forms metadata file.
  • --extensions: File extensions to analyze separated by comma. The default value is sql,pkg,pks,pkb.
  • --output-file: Path to the output file. The default value is zpa-issues.json.

The output file follows the "Generic Issue Data" format and it can be used in SonarCloud or in a SonarQube server (as an alternative to the dedicated Z PL/SQL Analyzer Plugin).

Example

Running an analysis:

./zpa-cli/bin/zpa-cli --sources .

Then you can send the results to a SonarCloud or SonarQube server setting the sonar.externalIssuesReportPaths property:

sonar-scanner 
  -Dsonar.organization=$SONARCLOUD_ORGANIZATION \
  -Dsonar.projectKey=myproject \
  -Dsonar.sources=. \
  -Dsonar.host.url=https://sonarcloud.io \
  -Dsonar.externalIssuesReportPaths=zpa-issues.json

Check the demo project on SonarCloud!