How to use setfine off

Hi ,

if i use set define off in my sql script to deployment is failing . How to use it .



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


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.