title: How can I retrieve multiple sys_refcursor using dapper and c#?
body: <p>I want to retrieve multiple sys_refcursors from oracle db using dapper.
  My PL/SQL code below</p>
  <pre><code>procedure GetData2 (p_result out sys_refcursor, p_result2 out sys_refcursor)
   is
   begin
     open p_result for
          select '1' col1, '2' col2 from dual
          union all
          select '11' col1, '22' col2 from dual;
          
     open p_result2 for
          select '3' col1, '4' col2 from dual;
   end;
  </code></pre>
  <p>And my c# code is below</p>
  <pre class="lang-cs prettyprint-override"><code>using OracleConnection connection = new OracleConnection();
  connection.ConnectionString = &quot;&quot;;
  connection.Open();
      
      
  OracleDynamicParameters parameters = new OracleDynamicParameters();
  parameters.Add(name: &quot;p_result&quot;, dbType: OracleMappingType.RefCursor, direction: ParameterDirection.Output);
  parameters.Add(name: &quot;p_result2&quot;, dbType: OracleMappingType.RefCursor, direction: ParameterDirection.Output);
      
  var reader = connection.QueryMultiple(&quot;TEST_PACKAGE.GetData2&quot;, param: parameters, commandType: CommandType.StoredProcedure);
      
  IEnumerable&lt;MyClasss&gt; dt = reader.Read&lt;MyClasss&gt;();
      
  foreach (var item in dt)
  {
      Console.WriteLine(item.col1);
  }
  </code></pre>
  <p>This c# code only gives me p_result table result.
  How can I retrieve two sys_refcursor results using dapper?</p>