title: Execute a stored procedure in Oracle from Azure Data Factory v2
body: <p>I have a list of copy activities that are dynamically triggered in my ADF pipeline parallelly to load data from Azure SQL to Oracle 9i Database. I have a requirement to update a Status Table on Oracle if all my loads are completed successfully.</p>
  <p>I tried multiple approaches provided in this community with no luck. Just wondering if I am missing anything. Any pointers please?</p>
  <p><strong>Approach 1 :</strong>
  Create a SP on Oracle :</p>
  <pre><code>CREATE OR REPLACE PROCEDURE AZ.UPDATE_LOOKUP_TEST AS
  BEGIN
  update AZ.STATUS_DIM set Status='Completed' where Database ='NLM';
  COMMIT;
  END;
  </code></pre>
  <p>ADF:
  Lookup Activty
  <a href="https://i.stack.imgur.com/J8UPD.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/J8UPD.png" alt="enter image description here" /></a></p>
  <p>Error details<br />
  Error code  2100
  Failure type<br />
  User configuration issue
  Details<br />
  ErrorCode=InvalidParameter,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The value of the property 'columns' is invalid: 'Value cannot be null. Parameter name: columns'.,Source=,''Type=System.ArgumentNullException,Message=Value cannot be null. Parameter name: columns,Source=Microsoft.DataTransfer.Common,'</p>
  <p><strong>Approach 2 :</strong></p>
  <p>Query in Lookup Activity :<br />
  EXECUTE AZURE45.UPDATE_LOOKUP_TEST;</p>
  <p>Error :</p>
  <p>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,'</p>
  <p><strong>Approach 3:</strong><br />
  Directly provide the update statement in the Query</p>
  <p>Query : update AZ.STATUS_DIM set Status='Completed' where Database ='NLM';</p>
  <p>Error :</p>
  <p>ErrorCode=InvalidParameter,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The value of the property 'columns' is invalid: 'Value cannot be null. Parameter name: columns'.,Source=,''Type=System.ArgumentNullException,Message=Value cannot be null. Parameter name: columns,Source=Microsoft.DataTransfer.Common,'</p>
  <p>How do I execute Oracle stored procedure from Azure datafactory?</p>