Skip to Main Content

SQLcl

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Issues with duplicate files since last SQLcl update

Alistair RedpathNov 18 2024

Hi everyone, I'm using the below command to export Oracle APEX apps to a git branch in SQLcl:

apex export -applicationid [app id] -exptype application_source -split -dir [directory]

It's been working fine until the recent update. Where it used to generate a file structure roughly like the below, with individual files added or updated only where there were changes, along with an updated install.sql as a controller:

  • f[app id]
    • application
      • page1.sql
      • page2.sql
      • page3.sql
    • environment
      • credential1.sql
    • install.sql

It now produces the below, with duplicates tagged "_1" after every file, which won't deploy correctly due to the incorrect file names:

  • f[app id]
    • application
      • page1.sql
      • page1_1.sql
      • page2.sql
      • page2_1.sql
      • page3.sql
      • page3_1.sql
    • environment
      • credential1.sql
      • credential1_1.sql
    • install.sql
    • install_1.sql

Nothing has been changed in these commands, as they'd been working fine for months. I can't spot anything in the release notes which would indicate why the new behaviour would occur - but maybe I'm just not seeing something obvious.

I've tried simply deleting the contents of the f[app id] folder first, but then we lose the commit info for the objects which is valuable to us.

This post has been answered by Markus Weber on Nov 18 2024
Jump to Answer
Comments
Post Details
Added on Nov 18 2024
2 comments
39 views