Hi ,
if i use set define off in my sql script to deployment is failing . How to use it .
Thx
Hi ,
if i use set define off in my sql script to deployment is failing . How to use it .
Thx
Hello,
As & in &(ampersand)nbsp; is considered as substitution variable in sql and liquibase ignores set define off statement , so I used ascii characters to use & in sql query defined in liquibase as below:
&(ampersand)nbsp; changed to ’ || ‘&’ || ‘nbsp’ || CHR(59) || ’ and query worked
Regards,
Ahmed
set define off is a sqlplus specific setting and will cause error with the default liquibase executor.
We had to remove all the set define off from our scripts.
There is runWith option to use sqlplus but it is only available ‘out of the box’ with the ‘PRO’ version of liquibase.