I am exploring Liquibase and hopefully can introduce into our dev environment. However, I am running into an error and i can’t get rid of it. I am simply trying to add a procedure.
create or replace PROCEDURE AddPerson (NewName varchar2) AS BEGIN INSERT INTO TEMPTABLE1 (NAME) VALUES(NewName); END; /
error is as follows
Unexpected error running Liquibase: ORA-00900: invalid SQL statement [Failed SQL: (900) END] liquibase.exception.MigrationFailedException: Migration failed for change set ./ChangeLog1212.xml::1::chuan.he:
my changelog xml for that particular piece is
<changeSet author="chuan.he" id="1"> <sqlFile path="./12.1.2/ADDPERSON.pls"/> </changeSet>
interesting part is that this does not fail completely, it actually put a broken piece of procedure into the database, which is kinda worse than complete failure. below is what got put into DB
create or replace PROCEDURE AddPerson (NewName varchar2) AS BEGIN INSERT INTO TEMPTABLE1 (NAME) VALUES(NewName)
so it ended at the first semicolon ; , making me think something wrong with it.
please help, i have no idea what the heck is going on.