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!

"project export" is missing workspace export and ORDS modules

Roel HartmanJan 16 2025

Using sqlcl’s “project export” command I am able to export most of my applications. But not all ….I am missing

  • a Workspace export - and then the workspace files in particular
  • my ORDS modules

ORDS :
Regarding the ORDS modules : running the export in debug mode reveals this error
Failed to export ords due to ORA-20857: Error retrieving parsing schema information - ORA-01403: no data found
ORA-06512: at “ORDS_METADATA.ORDS_EXPORT”, line 1092
ORA-06512: at “ORDS_METADATA.ORDS_EXPORT”, line 1155
ORA-06512: at “ORDS_METADATA.ORDS_EXPORT”, line 1167
I am running the export as PDB_ADMIN and that is assigned the ORDS_ADMINISTRATOR_ROLE - so what am I missing to get the ORDS modules out?
FYI, running that query as the “owner” of the ORDS Modules does return the correct data.

Workspace export:
I can add a custom file for the workspace and include that in my changelog as
<include file=“code/_custom/w1700184007129478.sql” relativeToChangelogFile=“true”/>
but as this file contains multipl anonymous PL/SQL blocks, the deployment fails with an “ORA-00900: invalid SQL statement” error.

I could also include similar for the exported files
<include file=“code/_custom/files_1700184007129478.sql” relativeToChangelogFile=“true”/>
but as these might change more frequently, I would love to see that included in a (regular) “project export” command. (edited)

This post has been answered by danmcghan-Oracle on Jan 19 2025
Jump to Answer
Comments
Post Details
Added on Jan 16 2025
2 comments
436 views