PL/SQL Analyzer v1.4.0

• Released on 2019-09-26
• Changed
  • PL/SQL grammar
    • Support keyword MOD and other keywords as query_name in the subquery_factoring_clause.
    • Support keyword ONE, e.g. as column alias.
    • Support keyword WELLFORMED, e.g. as parameter name.
    • Support keyword WORK, e.g. as parameter name.
  • Expose hints as new class named HintOrComment.
    • Customer have now access to source code details (e.g. start line, offset, etc.) via the PL/SQL parser.
    • This leads to a changed XML output structure (attribute instead of node).
    • The XPath expression to access hints changed from text() to @text.
  • Increased metadata versions
    • for database code to 9
    • for XML structure to 9
    • updates are installed on the first run
    • all source is processed on the first run
  • Updated PLSQL.xsd and HTML documentation to cover PL/SQL Parser version 2.1.12
  • Included preview/trial license is valid thru 2020-03-31
• Fixed
  • Parse error when using udf_pragma.
  • Parse error when using record with dot notation in values_clause of INSERT statement. For example INSERT INTO t VALUES in_param.rec.
  • Parse error when using NOT in expressions with A SET, NAN, INFINITE, PRESENT, EMPTY, JSON, OF TYPE. Fore example x IS NOT A SET.
• Won’t Fix
  • Support of keyword JSON in table name or table alias due to conflicts with JSON_condition.
  • Empty conditional compilation branches (see also Parser Limitations)