How to Create Procedure on HANA database through Liquibase

General Discussion
1

Hi 

Currently I am trying to create procedure on HANA database, but does not quite working, it is able to insert record into databasechangelog and does not show any error during the execution, however, it does not create the procedure in specified schema.  I will appreciate any response in the matter.  Thank you!

XML File:

<?xml version="1.1" encoding="UTF-8" standalone="no"?>

<databaseChangeLog xmlns=“http://www.liquibase.org/xml/ns/dbchangelog” xmlns:ext=“http://www.liquibase.org/xml/ns/dbchangelog-ext” xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance” xsi:schemaLocation=“http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.5.xsd”>

 

    <createProcedure catalogName=“sys”

dbms=“hana”

            encoding=“utf8”

            procedureName=“TESTHANA”

            relativeToChangelogFile=“true”

            schemaName=“LB_TEST”>create procedure TESTHANA () language SQLSCRIPT

AS

BEGIN

select 1 from dummy;

END;

2

Passing sql files into the xml just works fine, we will take it as resolution for now. 

	<sqlFile path="D:\xml\HANA\proc\proc_test.sql" splitStatements="false"/></div></div>