SonarQube
For project-level findings and team review.
- Runs through SonarScanner.
- Publishes issues and metrics in SonarQube.
- Can import Forms metadata and utPLSQL reports.
- Supports custom rule plugins.
ZPA parses database code into structured syntax, then applies checks that understand PL/SQL and Oracle SQL semantics.
Open source · LGPL-3.0 · SonarQube Community Build 26.2+
CREATE OR REPLACE PROCEDURE close_order(p_order_id NUMBER) IS v_status VARCHAR2(20); v_last_id NUMBER;BEGIN SELECT status INTO v_status FROM orders WHERE id = p_order_id;
IF v_status = NULL THEN RETURN; END IF;
SELECT id INTO v_last_id FROM orders WHERE ROWNUM <= 1 ORDER BY created_at DESC;
UPDATE orders SET status = 'CLOSED' WHERE id = p_order_id;END;Anonymous blocks, packages, procedures, functions and declarations are parsed as structured code.
SELECT and DML grammar inside database programs is available to rules as named syntax.
Object references can be checked when a project supplies Forms metadata. See the metadata format
The SonarQube plugin imports test execution and coverage reports alongside analysis results. Read the integration guide
Both use the same analyzer and built-in rules. Choose the integration that fits your workflow.
For project-level findings and team review.
For local analysis and CI jobs.