Skip to Main Content

SQLcl: MCP Server & SQL Prompt

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

apex export broken after upgrade to 24.2.5

Krisztian HegyvariJun 5 2025 — edited Jun 5 2025

Hello,

We did our obligatory update in OCI to apex version 24.2.5.

SQLcl: Release 24.1 Production on Thu Jun 05 14:53:14 2025

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

Last Successful login time: Wed May 07 2025 17:45:55 +02:00

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.27.0.1.0

I launch the export:

SQL> apex export -applicationid 100
Exporting Workspace I_WKS - application 100:App name
SQL>

The export file is not created, I have no error message. The application 100 exists of course.

With -debug

SQL> apex export -applicationid 100 -debug
Exporting Workspace I_WKS - application 100:App name

       begin  
               ? := apex\_export.get\_application (  
               p\_application\_id          => ?,  
               p\_split                   => ?='Y',  
               p\_with\_date               => ?='Y',  
               p\_with\_ir\_public\_reports  => ?='Y',  
               p\_with\_ir\_private\_reports => ?='Y',  
               p\_with\_ir\_notifications   => ?='Y',  
               p\_with\_translations       => ?='Y',  
               p\_with\_pkg\_app\_mapping    => ?='Y',  
               p\_with\_original\_ids       => ?='Y',  
               p\_with\_no\_subscriptions   => ?='Y',  
               p\_with\_comments           => ?='Y',  
               p\_with\_supporting\_objects => ?,  
               p\_with\_acl\_assignments    => ?='Y',  
               p\_components              => apex\_string.split( ? , ' '),  
               p\_type                    => ? );  
           end;

Start Thu Jun 05 15:40:49 CEST 2025
SQL>

Any ideas? The export from the APEX UI works.

Kind regards,

Krisztian

Comments
Post Details
Added on Jun 5 2025
4 comments
151 views