Skip to Main Content

SQLcl

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

SQLcl Project - Problem with liquibase compile order

Hi,

I'm working to integrate my database development process with SQLcl.

Right now, I don't find any documentation on how to change liquibase default order. Right now, when i export and stage, my stage.changelog.xml contains all my changes. The problem is that the order of objects seems wrong. For example, tables are compiled at the end after constraints or package bodies are compiled before package specs.

Can I specify somewhere to liquibase the default compiling order for my objects?

When seeking the solution I came across this option in project.config.json :

"stage" : { 
	...
	"changeLogSortOrder" : [ "USER", "TYPE_SPECS", "TYPE_BODY", ... ] 
}

Sadly it doesn't seem to be a real parameter since project config doesn't show any description for this.

Anyone got a solution about this?

Comments
Post Details
Added on Mar 6 2025
7 comments
190 views