title: Using Entity Framework 5 with overloaded Oracle stored procedures
body: <p>I have the following question.</p>
  
  <p>I have a couple of stored procedures in an Oracle database package. As it is, they differ in the number of parameters (I'm not allowed to touch or change the stored procedures).</p>
  
  <p>I was using ODP.NET and Entity Framework 5, with EntLib.Contrib.Data to manage access and manipulation of this database:</p>
  
  <pre><code>Database db = EnterpriseLibraryContainer.Current.GetInstance&lt;Database&gt;();
  ...
  using( var reader = db.ExecuteReader("SP_NAME", parameters[])
  {
       ...
  }
  </code></pre>
  
  <p>I HAVE to use parameter discovery because our framework is designed that way. Changing it is the last resource.</p>
  
  <p>I have been able to get access to SPs and functions using this method, but a problem arises when I try to to execute a SP that has an overload. Namely, an exception is thrown that I am not sending the right number of parameters to execute that SP. Only one of them is accessible (the one that was declared first in the package): the second throws this exception all the time. </p>
  
  <p>I tried passing the parameters one by one, in a List {}, in an object[], using ExecuteDataSet(), but it hasn't worked.</p>
  
  <p>Is there any way to make it happen?</p>
  
  <p>Thanks.</p>