Liquibase supports Oracle package compilation?

General Discussion
1

I’m looking for some info regarding the Liquibase oracle with Gitlab docker.
I see .sql files are executed correctly, but .pkb or .pks are skipped in v4.8.0

Legends & Leaders, Appreciate your help here!
Thanks!

2

Hi spbendekar! Welcome to the Liquibase Community.

Making some assumptions here, I assume you’re using the includeAll tag. If so, includeAll only picks up files with the following extensions: .sql, .yml, .xml, .json. We don’t currently support .pkb or .pks formats. If you would like to request support for that, you can join the discussion and add your use case to the issue on GitHub: Does Liquibase Support pks/pkb for migration? · Issue #33 · liquibase/liquibase-oracle · GitHub

Regards,
Tabby

1 Like
3

Thanks @tabbyfoo for your response.
Any chance we have this feature working in the near future?

1 Like
4

You could specify the file directly using include

For instance
<include file="packagebody.pkb" relativeToChangelogFile="true"/>

2 Likes
5

Just for my understanding: what about if we put a package into a sql-file, will that not work?

2 Likes
6

You can execute any PL/SQL from a .sql file. You just have to set the endDelimiter.

3 Likes