Code Snippet
public OracleDataReader ConsultaGenericaProc_DataReader(string _procedure, List<object[]> _parametros)
{
OracleDataReader resposta;
resposta = null;
try
{
using (OracleConnection oraConn = new OracleConnection(connString))
{
oraConn.Open();
using (OracleCommand oraCmd = new OracleCommand(_procedure, oraConn))
{
oraCmd.CommandType = CommandType.StoredProcedure;
oraCmd.Parameters.Add("O_RESULT_SET", OracleType.Cursor);
oraCmd.Parameters["O_RESULT_SET"].Direction = ParameterDirection.Output;
foreach (object[] obj in _parametros)
{
oraCmd.Parameters.AddWithValue(obj[0].ToString(), obj[1]);
}
OracleDataReader resposta2 = oraCmd.ExecuteReader();
return resposta = resposta2;
}
}
}