We have a sql formatted script with a single Insert statement. One of the columns contains a semi-colon in the string as shown below. Liquibase execution fails with “Error: ORA-00933: SQL command not properly ended”. I have tried to override the endDelimiter by adding “endDelimiter:”; ", but that does not work either. I cannot find any documentation on what regular expression syntax is allowed for the endDelimiter property. Has anyone encountered this or have a work-around?
--liquibase formatted sql
--changeset devops:scs-3504.1 dbms:oracle runOnChange:true failOnError:false splitstatements:false
Insert into EVENTS_OWNER.ALTDEF
(ALTALTID, ALTCLID, ALTDESC, ALTPARA, ALTPRI,
ALTDBID, ALTRUN, ALTDCRE, ALTDMAJ, ALTUTIL)
Values
('NEW_STOR_CHK',
'EVENTS',
'New',
'INITPROC=null;FINALPROC=null;REPORTNAME=NEW_STOR_CHK;FILENAME=NEW_STOR_CHK.xml;HOURS=0;PARAM1=0;PARAM2=0;PARAM3=0',
1,
'GOLD_PROD',
0,
sysdate,
sysdate,
'BATCH');