title: How to call Oracle stored procedure from azure data factory v2
body: <p>My requirement is copy data from Oracle to SQL Server. Before copying from Oracle database, I need to update the Oracle table using procedure which has some logic.</p>
  <p>How do I execute Oracle stored procedure from Azure datafactory?</p>
  <p>I referred <a href="https://stackoverflow.com/questions/51591123/oracle-store-procedure-in-azure-data-factory-v2">to this thread</a></p>
  <p>if I use <code>EXECUTE PROC_NAME (PARAM);</code> in <code>preCopy</code> script it's failing with following error</p>
  <pre><code>Failure happened on 'Source' side. 
  ErrorCode=UserErrorOdbcOperationFailed,
  Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException
  Message=ERROR [42000] [Microsoft][ODBC Oracle Wire Protocol driver]
  [Oracle]ORA-00900: invalid SQL statement
  Source=Microsoft.DataTransfer.ClientLibrary.Odbc.OdbcConnector,
  Type=System.Data.Odbc.OdbcException
  Message=ERROR [42000] [Microsoft][ODBC Oracle Wire Protocol driver]
  [Oracle]ORA-00900: invalid SQL statement,Source=msora28.dll
  </code></pre>
  <p>Could anyone help on this?</p>
  <p>Note: I am using self-hosted runtime environment for data factory
  thanks!!</p>