title: How to call a Stored Procedure inside an oracle package with Entity Framework?
body: <p>I have a package in oracle 11g as follow:</p>
  
  <pre><code>CREATE OR REPLACE PACKAGE "HRS.PKG_TRAINING_SP" as
  TYPE T_CURSOR IS REF CURSOR;
  
  procedure GETPERSONNELTRAINIGLIST(
          personnel_Id_in in string,
          base_date_in in string,
          is_current_in in number,
          lst OUT T_CURSOR );
  end;
  </code></pre>
  
  <p>How can I execute above procedure package (<code>GETPERSONNELTRAINIGLIST</code>) with Entity Framework (code-first)?</p>
  
  <p><strong>Note:</strong> I am using Entity Framwork 6.0 (code-first) and devart <code>EF Provider</code> for Oracle.</p>
  
  <p><strong>Updated:</strong>
  I am using following code:</p>
  
  <pre><code>var param1 = new OracleParameter("personnel_Id_in", OracleDbType.VarChar, "c5eb5589-8fee-47b6-85ad-261a0307cc16", ParameterDirection.Input);
  var param2 = new OracleParameter("base_date_in", OracleDbType.VarChar, "1112", ParameterDirection.Input);
  var param3 = new OracleParameter("is_current_in", OracleDbType.Number, 1, ParameterDirection.Input);
  
  var ATests =
      db.Database.SqlQuery&lt;ATest&gt;(
      "BEGIN PKG_TRAINING_SP.GETPERSONNELTRAINIGLIST(:personnel_Id_in, :base_date_in, :is_current_in); end;", 
      param1,  param2, param3).ToList();
  </code></pre>
  
  <p>but below error raised:</p>
  
  <pre><code>{"ORA-06550: line 1, column 7:\nPLS-00306: wrong number or types of arguments in call to 'GETPERSONNELTRAINIGLIST'\nORA-06550: line 1, column 7:\nPL/SQL: Statement ignored"}
  </code></pre>