lb genobject -type apex

Agustin Conejos

Hello,

I am using sqlcl 21.1 on

 cat /etc/*release o

Oracle Linux Server release 7.8

NAME="Oracle Linux Server"

VERSION="7.8"

trying to export an apex application with a priviliged user got the a nullpointerexception.

SQL> lb genobject -type apex -applicationid 1000 -skipExportDate -expOriginalIds -split

May 21, 2021 9:01:45 AM oracle.dbtools.raptor.newscriptrunner.ScriptExecutor run

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

java.lang.NullPointerException

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

    at oracle.dbtools.raptor.newscriptrunner.CommandRegistry.fireListeners(CommandRegistry.java:346)

    at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.run(ScriptRunner.java:226)

    at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:344)

    at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:227)

    at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.process(SqlCli.java:421)

    at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.processLine(SqlCli.java:432)

    at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.startSQLPlus(SqlCli.java:1333)

    at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.main(SqlCli.java:513)

Please help.

Scott Wesley

Try a 20.x version of SQLcl.

It worked for us.

Scott Wesley

Try a 20.x version of SQLcl.

It worked for us.

Agustin Conejos

thanks @Scott Wesley ....

It looks like a bug from version 21

SQL> lb genobject -type apex -applicationid 1000 -skipExportDate -expOriginalIds -split

Exporting application 1000

 Completed at Mon May 24 08:52:30 CDT 2021

Action successfully completed please review created file controller.xml

Regards

Agustin Conejos

@Scott Wesley

one quick question...

i just noticed even though i executed the command line on the path i wanted

the lb genobject command created the whole path twice

SQL> pwd

/home/user/repo/apex/home/user/repo/apex/f1000/application/

1- i moved to / and executed sqlcl from there hoping the $HOME path will only be once

SQL> lb genobject -type apex -applicationid 1000 -skipExportDate -expOriginalIds -split

Exporting application 1000

 Completed at Mon May 24 09:07:30 CDT 2021

Processing has failed for your request.

/f1000/application/init.xml (No such file or directory)

(looks like it was not concatenated here)

:-/

2- I tried passing the "-dir" parameter in the documentation but is not working yet

SQL> pwd

/home/user/repo/apex/

SQL> lb genobject -type apex -applicationid 1000 -dir /home/user/repo/apex -split

Processing has failed for your request.

ERROR: Unknown parameter -dir

Scott Wesley

Huh, I actually found the -dir parameter only worked for APEX, and not other object types

https://community.oracle.com/tech/developers/discussion/4484768/exporting-to-specified-folder-using-dir

Though I'm very early exploration days, so I'm not much help.

Agustin Conejos

@Scott Wesley thanks a lot men!

i think i am going to downgrade a little more maybe i can find a client to suits my needs

Agustin Conejos

SQLcl: Release 20.2 Production on Tue May 25 08:58:43 2021

Copyright (c) 1982, 2021, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> lb genobject -type apex -applicationid 1300 -dir /dev/repo/ -split

Processing has failed for your request.

ERROR: Unknown parameter -dir

i tried again SAME as you described without luck on

oracle linux 7.8 Operative system and both

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production

Version 18.12.0.0.0