I am trying to create multiple stored procedures using tag of liquibase.
File contents are
CREATE PROCEDURE RECS_INS (IN R_ID Integer, IN R_Name Varchar(100))
DYNAMIC RESULT SETS 0
MODIFIES SQL DATA
INSERT INTO RECS
VALUES (R_ID, R_Name);
I am facing issues with both statement terminator semicolon as well as go.
Please let me know how to handle statement terminators for stored procedures/triggers etc. Since there is need of two terminators.