Skip to content

Oracle Forms support

Felipe Zorzo edited this page Apr 12, 2018 · 5 revisions

In Oracle Forms, many builtins need a reference to an object (blocks, items, alerts...) but the only way to pass a reference to an object is using a VARCHAR2 variable and these references are not checked by the compiler.

There is a special rule in this plugin targeting these Oracle Forms builtins: Invalid reference to Oracle Forms object (plsql:InvalidReferenceToObject).

To use this rule you must provide a file with some information about the structure of the form. The file should be structured like:

{
  "alerts": ["MY_ERROR", "MY_WARNING"],
  "blocks": [
    {
      "name": "EMPLOYEES",
      "items": ["EMPLOYEE_ID", "FIRST_NAME", "LAST_NAME"]
    },
    {
      "name": "DEPARTMENTS",
      "items": ["DEPARTMENT_ID", "DEPARTMENT_NAME"]
    }
  ],
  "lovs": ["LIST_OF_EMPLOYEES", "LIST_OF_DEPARTMENTS"]
}

To enable any rules targeting specifically Oracle Forms, you should provide the property sonar.plsql.forms.metadata=file.json=file.json to the SonarQube Scanner.

Clone this wiki locally