Skip to Main Content

SQLcl

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

SQLcl 23.4: lb generate-apex-object doesn't work with -expType beyond APPLICATION_SOURCE

Simon_DBAFeb 16 2024

As of SQLcl version 23.4, the only export lb generate-apex-object type that still works is APPLICATION_SOURCE. Errors with:

No Data Found please verify your information.
Apex object was not found, please verify inputs.

Although the other options do still work with apex export.

Example using SQLcl: Release 23.3:

SQL> apex export -applicationid 101 -expType APPLICATION_SOURCE,READABLE_YAML
Exporting Workspace APPS - application 101:TestApp
File readable/workspace/credentials.yaml created

SQL> lb generate-apex-object -applicationid 101 -expType APPLICATION_SOURCE,READABLE_YAML
--Starting Liquibase at 12:24:14 (version 4.18.0 #5864 built at 2022-12-02 18:02+0000)

Exporting Workspace APPS - application 101:TestApp
Command completed successfully please review file apex_install.xml
Operation completed successfully.

SQL>

But then after upgrading to: SQLcl: Release 23.4

SQL> apex export -applicationid 101 -expType APPLICATION_SOURCE,READABLE_YAML
Exporting Workspace APPS - application 101:TestApp
File readable/workspace/credentials.yaml created

SQL> lb generate-apex-object -applicationid 101 -expType APPLICATION_SOURCE,READABLE_YAML
--Starting Liquibase at 2024-02-16T12:27:19.824009 (version [local build] #0 built at 2023-11-06 22:02+0000)

Exporting Workspace APPS - application 101:TestApp
No Data Found please verify your information.
Apex object was not found, please verify inputs.
Operation completed successfully.

SQL>

Doesn't seem to matter if the options such as READABLE_YAML are used by themselves, or in a comma separated list. Always fails.

Exact SQLcl version: SQLcl: Release 23.4.0.0 Production Build: 23.4.0.023.2321
Database version: 23.3.0.23.09

Comments
Post Details
Added on Feb 16 2024
1 comment
168 views