Oracle SQLcl 24.3.2 Release Notes

Version 24.3.2.330.1718

November 2024

SQLcl on OTN | Getting Started Video | Downloads | FAQ | Forum

 

Issues Fixed in 24.3.2

This patch addresses PROJECT command issues and various bugs fixes:

  • 36664857 WHEN MOVING A DEPLOYMENT FROM WINDOWS TO LINUX, LIQUIBASE STATUS SHOWS INCORRECT STATUS
  • 36680641 CUSTOM CHANGE TYPES LOG INCONSISTENT VALUES DEPENDING ON OPERATING SYSTEM
  • 37288522 MLE COMMAND SHOULD SAY DATABASE VERSION INSTEAD OF JUST VERSION
  • 37290603 UNABLE TO DEPLOY APEX APPLICATION USING DATABASE APPLICATION CI/CD
  • 37101392 EXPORT COMMAND ISSUE WHEN EMITSCHEMA = FALSE IN TRIGGERS
  • 37238499 PROJECT STAGE APPLIES TRANSFORMS WITHOUT CHECKING THE OBJECT TYPES IN DBMS_METADATA.SET_TANSFORM_PARAM
  • 37254389 PROJECT STAGE USES CURRENT BRANCH WHEN PASSING A DIFFERENT BRANCH FOR DIST DIRECTORY NAME
  • 37259250 "PROJECT STAGE" ONLY WORKS WHEN ALL FILES ARE COMMITTED
  • 37266461 EXPORT OBJECT HELP SHOULD CONTAIN OBJECTS INSTEAD OF SCHEMAS
  • 37274003 PROJECT EXPORT CUSTOM FILTER ERROR
  • 37274458 TYPE_BODY EXPORTED FILE NAME CONTAINS A _BODY.SQL SUFFIX
  • 37279254 PROJECT EXPORT -LIST OUTPUTS EXPORTED 0 OBJECTS
  • 37283403 PROJECT SQL FORMATS ARE NOT APPLIED TO STAGE DROP STATEMENT
  • 37300400 PROJECT STAGE DOES NOT GENERATE REVOKE STATEMENTS CORRECTLY
  • 37300489 PROJECT STAGE GENERATES COMMENTED OUT PACKAGE


    • If your bug fix isn’t listed above, please refer to My Oracle Support to check its status.

    Support

    You are supported by Oracle Support under your current Oracle Database Support license.

    Log Oracle SQLcl bugs and issues using My Oracle Support. To determine the version of SQLcl run this command: sql -version

    Documentation

    Documentation on using SQLcl is provided on the oracle.com website here.

    Requirements

    • Supported Java Version
      • Oracle SQLcl requires Java 11 or 17 or 21. The supported Java Runtime Environments are:
        • Oracle Java 11
        • Oracle Java 17
        • Oracle Java 21
        • Oracle GraalVM Enterprise Edition for Java 11
        • Oracle GraalVM Enterprise Edition for Java 17
        • Oracle GraalVM Enterprise Edition for Java 21
    • JavaScript support requires Oracle Java 11 or GraalVM for Java 17 with the JavaScript Runtime Plugin

    Restrictions

    This section describes the restrictions on use.

    ORACLE_HOME usage

    When using an ORACLE_HOME or instant client with SQLcl, the client version must be 23ai.

    Liquibase usage with APEX

    Liquibase support for APEX requires APEX version 18 and above.

    Feedback

    In the forum, you can discuss topics with the SQLcl community around the world and leave feedback for the development team.

    Be sure to use clear subject lines to initiate a thread. Provide a complete and clear description of the issue, including steps to reproduce the issue.

    Try to avoid using old, unrelated threads for a new issue.