title: Update a row in oracle using OLEDB command(SSIS)
body: <p>I am trying to update some rows in an oracle Database, using an OLEDB Command <br/>
  but whenever i try specifying the Sql Command this is what i get<br/></p>
  
  <pre><code>An OLEDB record is available. Source: "OraOLEDB" Hresult:0x80040E51 Description:
  "Provider cannot derive parameter information and
   SetParameterInfo has not been called."
  </code></pre>
  
  <p>I have tried using </p>
  
  <blockquote>
    <p>"Native OLE DB\Oracle Provider for OLE
    DB" provider</p>
  </blockquote>
  
  <p>and i tried changing to </p>
  
  <blockquote>
    <p>"Native OLE DB\Microsoft OLE BD Provider for Oracle" provider</p>
  </blockquote>
  
  <p>but i get the same error, please help,
  I am using ssis 2008</p>
  
  <p>Here is the setup : The Connection Manager is as below <br/>
  <img src="https://i.stack.imgur.com/rMbtQ.jpg" alt="enter image description here">
  <br/><br/>
  When i test it, it succeeds <br/><br/>
  <img src="https://i.stack.imgur.com/bW1WI.jpg" alt="enter image description here"></p>
  
  <p><br/><br/>
  Now when i come to configuring the OLEDBCommand., I pass in the Connenction Manager<br/>
  <img src="https://i.stack.imgur.com/9dbjN.jpg" alt="enter image description here">
  <br/><br/>
  specify the command
  <br/>
  <img src="https://i.stack.imgur.com/EbwKg.jpg" alt="enter image description here">
  <br/><br/>
  now when i move to configure the parameters, nothing is displayed and i receive this error
  <br/>
  <img src="https://i.stack.imgur.com/tSLoH.jpg" alt="enter image description here">
  <br/><br/>
  thanks for the help</p>