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 stage command: wrong order in stage.changelog.xml

nico.j.klaverJun 30 2025

sqlcl -version: Release 25.1.1.0 Production Build: 25.1.1.113.2054

When you have a new table and grants on that table to an existing schema, the project stage command will place the grants before the table creation changes in stage.changelog.xml. This will result in an error during deploy.

Workaround is edit the stage.changelog.xml and moving the grants after the table creation changes. Not ideal

I think this is a bug.

Comments
Post Details
Added on Jun 30 2025
1 comment
53 views