Liquibase® version 3.8.2 is now available! Get it for free.
2018 XML Announcement
News 5 Ways to Fix a Bad Database Change in Liquibase
04 Dec 2019

- and/or -

All Previous Posts >>

Change: ‘createPackage’

Creates a package

Available Attributes

NameDescriptionRequired ForSupportsSince
catalogNameName of the catalogall
commentsall
dbmsall3.1
encodingall
packageNameName of the package to dropallall
packageTextallall
pathFile containing the procedure text. Either this attribute or a nested procedure text is required.all
procedureTextall
relativeToChangelogFileall
replaceIfExistsall
schemaNameName of the schemaall
<changeSet author="liquibase-docs" id="createPackage-example">
    <pro:createPackage catalogName="cat"
            comments="A String"
            dbms="h2, oracle"
            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
      comments: A String
      dbms: h2, oracle
      encoding: UTF-8
      packageName: A String
      packageText: A String
      path: com/example/my-logic.sql
      procedureText: |-
        CREATE OR REPLACE PROCEDURE testHello
            IS
            BEGIN
              DBMS_OUTPUT.PUT_LINE('Hello From The Database!');
            END;
      relativeToChangelogFile: true
      replaceIfExists: false
      schemaName: public
{
  "changeSet": {
    "id": "createPackage-example",
    "author": "liquibase-docs",
    "changes": [
      {
        "createPackage": {
          "catalogName": "cat",
          "comments": "A String",
          "dbms": "h2, oracle",
          "encoding": "UTF-8",
          "packageName": "A String",
          "packageText": "A String",
          "path": "com/example/my-logic.sql",
          "procedureText": "CREATE OR REPLACE PROCEDURE testHello\n    IS\n    BEGIN\n      DBMS_OUTPUT.PUT_LINE('Hello From The Database!');\n    END;",
          "relativeToChangelogFile": true,
          "replaceIfExists": false,
          "schemaName": "public"
        }
      }]
    
  }
}

Database Support

DatabaseNotesAuto Rollback
DB2SupportedNo
DB2SupportedNo
DerbySupportedNo
FirebirdSupportedNo
H2SupportedNo
HyperSQLSupportedNo
INGRESSupportedNo
InformixSupportedNo
MariaDBSupportedNo
MySQLSupportedNo
OracleSupportedNo
PostgreSQLSupportedNo
SQL ServerSupportedNo
SQLiteSupportedNo
SybaseSupportedNo
Sybase AnywhereSupportedNo