This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,889,823 Users
  • 2,269,775 Discussions
  • 7,916,823 Comments

Discussions

runOracleScript with file and relative path

Alex Nuijten
Alex Nuijten Member Posts: 242 Silver Badge

Is there a way to use relative path when using runOracleScript in a changeSet?

This works:

<n0:runOracleScript sourceType="FILE" ownerName="WKY" objectName="SCRIPT">

<n0:source>

<![CDATA[/Users/alexnuijten/Projects/demo-scripts/vat_test.sql]]>

</n0:source>

</n0:runOracleScript>


but this doesn't work (even when the controller and file vat_test.sql are in the same folder):

<n0:runOracleScript sourceType="FILE" ownerName="WKY" objectName="SCRIPT">

<n0:source>

<![CDATA[vat_test.sql]]>

</n0:source>

</n0:runOracleScript>


This would be helpful, our developers use different OS (Windows and Apple) and have the Git-repository checked out in a place where they see fit.