Does Liquibase support recompilation of code, such as packagebody, when it has been marked as invalid in Oracle

Applies to

• Liquibase Secure (Pro)
• Liquibase Community (Open Source)

Conditions

• Any version of Liquibase Secure (Pro) or Community
• 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.