0

I am using following syntax in Changelog file 

<changeSet author="demouser" id="demochangeset333" dbms="oracle">
    <sql>CALL LiquiInsert('ABC','1.0.3.4','ABC');</sql>
</changeSet>

It get call well from sqlplus that is outside of liquibase but gives Error

ORA-06576: not a valid function or procedure name session is altered correctly

This work fine from outside ..

Open to suggestions..

Procedure consists of just an insert statement - nothing else...

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Abhishek
  • 101
  • 3
  • 8

2 Answers2

0

try this:

<changeSet author="demouser" id="demochangeset333" dbms="oracle"> <sql> begin execute LiquiInsert('ABC','1.0.3.4','ABC'); end; </sql> </changeSet>

bilak
  • 4,526
  • 3
  • 35
  • 75
0

Use

<sqlFile
path=“xxx.sql”
relativeToChangelogFile=“true”
stripComments=“true”
splitStatements=“false”
endDelimiter=“/”
dbms=“oracle”
/>

and .sql file should have

BEGIN
    package.function();
END;
/
Abhay Singh
  • 1