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/APEX: project export/deploy: deploying application with "web credentials" fails

Oleg PyatnychkoApr 28 2025

When exporting an APEX application with web credentials, the SQLcl “project export” generates statements to create web credentials in target workspace without checking if they already exist.

This causes “project deploy” to fail.

--application/delete_application
wwv_flow_imp.remove_flow(...

--application/create_application
wwv_imp_workspace.create_flow(...

--workspace/credentials/syntaxmz_ociopsd_apex_lab_lab_app_oidc
wwv_imp_workspace.create_credential(...
^^^ this fails

What is the recommended way to handle this?

This post has been answered by danmcghan-Oracle on May 2 2025
Jump to Answer
Comments
Post Details
Added on Apr 28 2025
3 comments
331 views