Formatter Settings for SQLcl 23.4.0

Settings for

• Oracle SQLcl, Version 23.4.0
• Oracle SQL Developer, Version 23.1.1.345 (requiresdbtools-common.jar from SQLcl 23.4.0 usingParseNode.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 inOracle 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 standalonetvdformat.jar requires JDK 17 or newer (due to the latest JavaScript engine).

SeePatching 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 describedhere. 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 oldParseNode.class to ensure that the "Code Outline" continues to work in SQLDev).

Fixed

• #264 Unwanted line break afterwhenever oserror breaks code
• #265 Wrong indentation in subqueries ofinsert statements
• #266 Unwanted line break beforeon conversion error in subquery
• #267 Untwanted formatting of out-of-scope statements such asgrant

Seemain branch for the latest version.