Skip to content

Analyzer: Determine function invocations #92

@KieranKaelin

Description

@KieranKaelin

Goal

Given a function, procedure, query or trigger,, the analyzer should list each function invocation, including the amount of calls.

Example

CREATE PROCEDURE secure_dml
    IS
BEGIN
  IF
TO_CHAR (SYSDATE, 'HH24:MI') NOT BETWEEN '08:00' AND '18:00'
        OR TO_CHAR (SYSDATE, 'DY') IN ('SAT', 'SUN') THEN
      RAISE_APPLICATION_ERROR (-20205, 'You may only make changes during normal office hours');
END IF;
END secure_dml;

Invocations:

  • RAISE_APPLICATION_ERROR: 1
  • SYSDATE: 2
  • TO_CHAR: 2

How to demo

Rust and TS tests demonstrate the new analyzer statistics.

Metadata

Metadata

Assignees

No one assigned

    Labels

    analyzerAnalyzing of PL/SQL codeenhancementNew feature or requestwasmWASM interface changes

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions