createPackage
Note: This is a Liquibase Pro Change Type, so you need a Liquibase Pro License Key to use it.
Creates a package.
Available attributes
Name | Description | Required for | Supports | Since |
---|---|---|---|---|
catalogName
|
Name of the catalog |
all | ||
dbms
|
Specifies which database type |
all | 3.1 | |
encoding
|
Encoding used in the file defined in the |
all | ||
packageName
|
Name of the package |
all | all | |
packageText
|
The SQL creating the package |
all | all | |
path
|
File containing the procedure text. Either this attribute or a nested procedure text is required. |
all | all | |
procedureText
|
The SQL creating the procedure. You need to define either this attribute or the |
all | all | |
relativeToChange
|
Specifies whether the file path is relative to the changelog file rather than looked up in the search path. Default: |
all | ||
replaceIfExists
|
Boolean. If the stored procedure defined by |
all | ||
schemaName
|
Name of the schema |
all |

...
<changeSet author="liquibase-docs" id="createPackage-example">
<pro:createPackage catalogName="cat"
dbms="h2, !oracle, mysql"
encoding="UTF-8"
packageName="A String"
path="com/example/my-logic.sql"
relativeToChangelogFile="true"
replaceIfExists="false"
schemaName="public">A String</pro:createPackage>
</changeSet>
...

...
- changeSet:
id: createPackage-example
author: liquibase-docs
changes:
- createPackage:
catalogName: cat
dbms: h2, !oracle, mysql
encoding: UTF-8
packageName: A String
packageText: A String
path: com/example/my-logic.sql
relativeToChangelogFile: true
replaceIfExists: false
schemaName: public
...

...
{
"changeSet": {
"id": "createPackage-example",
"author": "liquibase-docs", "changes": [{
"createPackage": {
"catalogName": "cat",
"dbms": "h2, !oracle, mysql",
"encoding": "UTF-8",
"packageName": "A String",
"packageText": "A String",
"path": "com/example/my-logic.sql",
"relativeToChangelogFile": true,
"replaceIfExists": false,
"schemaName": "public"
}
}]
}
}
...
Database support
Database | Notes | Auto Rollback |
---|---|---|
DB2/LUW | Supported | No |
DB2/z | Supported | No |
Derby | Supported | No |
Firebird | Supported | No |
H2 | Supported | No |
HyperSQL | Supported | No |
INGRES | Supported | No |
Informix | Supported | No |
MariaDB | Supported | No |
MySQL | Supported | No |
Oracle | Supported | No |
PostgreSQL | Supported | No |
Snowflake | Not Supported | No |
SQL Server | Supported | No |
SQLite | Supported | No |
Sybase | Supported | No |
Sybase Anywhere | Supported | No |