ZPA

An open source parser and code analyzer for PL/SQL and Oracle SQL code.

What is this?

The Z PL/SQL Analyzer (or simply ZPA) is a code analyzer for PL/SQL and Oracle SQL code and it's available as a plugin for SonarQube on-premise instances.

NewYou can use the new ZPA CLI to analyze your code and report the issues to SonarCloud.

Features

Bug detection

More than 50 rules to detect bugs and code smells in Oracle SQL, PL/SQL and Oracle Forms code.

Metrics

It feeds SonarQube with many metrics about your code (size, complexity, duplications, etc.).

Extensibility

You can use the full power of the parser to create your own coding rules.

Speed

Up to 9x faster than the commercial SonarQube plugin.

Examples

Detect duplicated implementations in the same IF structure.

Example of issue reported on a code showing an IF/ELSE with the same content

Source

Check for incorrect comparisons with '' and NULL.

Example of issue reported on "v_value.get_string = ''"

Source

Find incorrect references to Oracle Forms objects and avoid "Cannot find <object>: Invalid ID" exceptions in runtime.

Example of issue reported on GO_ITEM to an item that doesn't exist on the form

Source

ZPA CLI

NewZPA CLI is a command-line interface to Z PL/SQL Analyzer. It allows you to run all the checks without a SonarQube installation.