Hi, Triggers/SQL Types/Procedures not working in H2. Liquibase version :3.5.3 Samples in my sql file ----------------------------- create or replace PROCEDURE myProc END myProc; /
Trigger:- --------- CREATE OR REPLACE TRIGGER my_trigger After INSERT OR UPDATE ON sample_TBL end; / Tried adding endDelimiter like below:- But getting the error like below:- Reason: liquibase.exception.DatabaseException: Syntax error in SQL statement "CREATE OR REPLACE TRIGGER [ERROR]
/ "; expected "., INSTEAD, BEFORE, AFTER"; SQL statement:
The same error exists for SQL types and function creation.Please help.
Thanks.