What is this?

Z PL/SQL Analyzer is a code analyzer for Oracle PL/SQL and Oracle Forms projects. It's avaliable as a SonarQube plugin. SonarQube is an open platform to manage code quality.

This plugin is completely free. It supports SonarQube Community 6.7.x and newer.

Features

  • Bug detection

    More than 40 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.

Examples

Detect duplicated implementations in the same IF structure.

Source

Check for incorrect comparisions with '' and NULL.

Source

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

Source

Coming next

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

zpa-forms-extractor extracts the source code from Oracle Forms modules to execute an analysis. It supports Oracle Forms 6i and later (up to 12c).