Skip to Main Content

SQLcl

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Please ask technical questions in the appropriate category. Thank you!

Does SQLCL Liquibase support parameter substitution

User_VM6IPJun 16 2022 — edited Jun 16 2022

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

Comments
Post Details
Added on Jun 16 2022
1 comment
97 views