SQLcl 23.4.0

Formatter Settings for SQLcl 23.4.0

Settings for

• Oracle SQLcl, Version 23.4.0
• Oracle SQL Developer, Version 23.1.1.345 (requires dbtools-common.jar from SQLcl 23.4.0 using ParseNode.class from SQL Developer 23.1.1.345)

These settings have been defined and tested with the product versions mentioned above. They might not work in other versions.

Please note, that these settings cannot be used in Oracle SQL Developer for VSCode 23.4.0. And it does not work in the embedded version of SQLcl 23.3.1.0, which cannot run JavaScript.

JDK 11 is required for SQLDev and SQLcl. The standalone tvdformat.jar requires JDK 17 or newer (due to the latest JavaScript engine).

See Patching SQL Developer for background information and instructions.

New

• #269 Support SQLcl 23.4.0
  • The new parser can deal with stored Java procedures (it does not report syntax errors anymore).
  • If we detect Java procedures we disable the process to convert quoted identifiers to unquoted identifiers to ensure we don't treat Javas strings as quoted identifiers and break the code. As a result, files and buffers containing Java procedures are now formatted.
  • Native images are not part of a release. You have to build them yourself as described here. This works again since SQLcl removed the use of GUI components in the relevant code path (which is BTW the reason we need to include the old ParseNode.class to ensure that the "Code Outline" continues to work in SQLDev).

Fixed

• #264 Unwanted line break after whenever oserror breaks code
• #265 Wrong indentation in subqueries of insert statements
• #266 Unwanted line break before on conversion error in subquery
• #267 Untwanted formatting of out-of-scope statements such as grant

See main branch for the latest version.