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!

Subject: SQLcl Project Command - Issue with APEX Application Owner on Export

Alex Payome11 hours ago

Hello everyone,

I'm using the project command in SQLcl to automate the deployment of my APEX application. My goal is to export only the application, so I have configured my project.filters file with the following line:

export_type = 'APEX_APPLICATIONS'

The export works, but I've encountered an issue with the application's ownership. The generated export file (f<app_id>.sql) sets the application owner to the workspace's provisioning schema, not the application's actual parsing schema.

This is causing permission conflicts in the target environment, as the objects it needs to access belong to the parsing schema, not the workspace owner.

My question is: How can I configure the project export command to correctly set the application's owner to its parsing schema instead of defaulting to the workspace schema?

Thank you for your help.

Comments
Post Details
Added 11 hours ago
0 comments
9 views