Applies to
- Liquibase Pro
- Liquibase Open Source (Community)
Conditions
- Any version of Liquibase Pro or Open Source
- Oracle Database
Question
Does Liquibase support recompilation of code, such as PACKAGEBODY
, when it has been marked as invalid in Oracle?
Answer
Liquibase itself does not directly handle recompiling invalid objects like PACKAGEBODY
in Oracle.
However, you can use Liquibase to execute custom SQL statements that trigger recompilation. This can be done by using a changeset that contains Oracle-specific ALTER
or EXEC
commands to recompile invalid objects.
For example, using an XML changeset:
<changeSet id="1" author="liquibase_support">
<sql>ALTER PACKAGE my_package COMPILE;</sql>
</changeSet>
This approach allows you to handle recompilation during the deployment process.
Comments
0 comments
Article is closed for comments.