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!

Sqlcl Project and remote servers?

Lukasz WasylowJun 17 2025

Hi,

I was wondering if anyone else had same problem, and how it solved it?

Using projects to deliver apex from dev to prod and all is great apart from remote servers between environments.

Due to way apex files are exported and app sql created only way to remap them as part of pipeline is to modify that file manually to add set remote server procedure with appropriate substitution e.g. dev.com, test.com etc.

Did someone found better way of doing it apart from manually change in workspace?

Feels like remote servers should be set on workspace level same as we credentials.

Cheers Lukasz

Comments
Post Details
Added on Jun 17 2025
2 comments
110 views