Skip to content

PL/SQL Cop for SQL Developer v2.3.1

Choose a tag to compare

View all tags
@PhilippSalvisberg PhilippSalvisberg released this 29 Mar 16:11
v2.3.1
db535bc
  • Fixed

    • Common

      • incomplete results when analyzed source code contains TREAT (due to NPE, see #1)
      • When using a own validator with a different guideline naming scheme the configured severity and characteristics per guideline are not honored and the defaults are reported (Blocker for severity and all characteristics)

    • Guidelines

      • G-7230 should not be thrown for constants in package specifications (see #79)

    • SQL*Plus grammar

      • Wrong line reported after comment lines ending on slash (/) for files using Unix line separators

    • PL/SQL grammar

      • Parse error when JSON_value_return_type is not defined.
        Documentation changed between version 12c and 18c. However, the following code works in Oracle Database 12c Release 1:

        SELECT *
  FROM JSON_TABLE (
          (SELECT '{"col1":"foo"}' doc FROM dual), 
          '$' COLUMNS (col1  PATH '$.col1')
       );

      • Parse error when a row_limiting_clause is used without an order_by_clause

      • Parse error when using expressions for offsetor rowcount in row_limiting_clause

Assets 3
Loading