Can not genobject -type apex

user11078851

Apex release 20.1

SQLCL 21.1.1.113.1704

Java 64 java version "16.0.1" 2021-04-20

lb genobject -type apex -applicationid 199

2021-07-15 00:51:33.282 SEVERE oracle.dbtools.raptor.newscriptrunner.ScriptExecutor run oracle.dbtools.raptor.scriptrunner.commands.liquibase.liquibaseCommand.handleEvent(liquibaseCommand.java:230)

java.lang.NullPointerException: Cannot invoke "java.lang.Exception.getMessage()" because "e1" is null

    at oracle.dbtools.raptor.scriptrunner.commands.liquibase.liquibaseCommand.handleEvent(liquibaseCommand.java:230) etc.

Johannes M

Have you tried with java8? And the apex export command from sqlcl? Are those working?

For me the export is working fine, however with -split broken export files are generated.

As a side note: is there any advantage of using lb genobject over apex export?

Johannes M

Are you aware that the latest release is 21.2.1.195.1252? Is there any reason for not using this release?

user11078851

Thnaks with release 21.2.1.195.1252 BUT please look at my ticket with lb updatesql when I generate XML file by genobject -type apex the file is coded UTF-8 but the inside script in PL/SQL is a trash like ANSI by UTF-8 and can not be update

Johannes M

Hi,

Yes I think this another bug of sqlcl. I did best by setting -Dfile.encoding=UTF-8

See also

https://www.thatjeffsmith.com/archive/2016/08/unicode-and-oracle-sqlcl-on-windows/

Br

user11078851

changing command prompt to 65001 did not improve