db* CODECOP v5.0.0

New / Changed

PL/SQL & SQL Grammar

• Support New Features/Changes in SQL Grammar 23c (#23)

• Support New Features/Changes in PL/SQL Grammar 23c (#22)

• Support New Features/Changes in SQL*Plus Grammar 23c (#20)

• Support New Features/Changes in SQLcl Grammar 23.4 (#21)

• The use as unquoted identifiers has been restricted for the following keywords:

  • escape (as custom data type)
  • final (as custom data type)
  • member (as column alias, custom data type)
  • running (as custom data type)
  • table (everywhere except data type)

  Please note that a parsing error caused by the use of a keyword as an unquoted identifier is not considered a db* CODECOP bug, see also Use of Keywords

Validators

• All validator checks are based on PL/SQL & SQL Coding Guidelines Version 4.4.
• All validator checks are updated based on changes in the underlying grammar
• Implemented new guideline G-3330: Avoid autonomous transactions.
• Registered new guideline G-4387: Never use a FOR LOOP for a query that should return not more than one row.
• Do not report G-7440 when in out is used for self as part of a fluent API (#27)

License File

• A new license file is required for this version
• Included preview/trial license is valid thru 2025-01-01