Forum Stats

  • 3,825,285 Users
  • 2,260,497 Discussions
  • 7,896,481 Comments

Discussions

Does SQLCL Liquibase support parameter substitution

User_VM6IP
User_VM6IP Member Posts: 1 Green Ribbon
edited Jun 16, 2022 5:41AM in SQLcl

Hi,

I am trying to use liquibase to automate running of scripts .The scripts are plsql sqplus format and have parameters that need to be substituted .

My change set looks like below

  <changeSet author="tim" id="create_dev_workspace_v1" failOnError="true" >

    <n0:runOracleScript objectName="create_workspace" ownerName="DEV_WS" sourceType="FILE" >

      <n0:source>

        <![CDATA[C:mySample.sql ]]>

      </n0:source>

    </n0:runOracleScript>

  </changeSet>

and the mySample.sql (for example)

BEGIN

    v_taskName := '&task';

thanks in advance

Tagged: