public DataSet GetDataset(string strCommandText, OracleParameter[] arrOracleParameters)
{
OracleCommand cmd = new OracleCommand();
try
{
cmd.CommandText = strCommandText;
cmd.CommandType = CommandType.StoredProcedure;
if ((arrOracleParameters == null) == false)
{
cmd.Parameters.AddRange(arrOracleParameters);
}
connObjOra.Open();
cmd.Connection = connObjOra;
OracleDataAdapter da = new OracleDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
connObjOra.Close();
da.Dispose();
da = null;
return ds;
}
catch (Exception ex)
{
throw ex;
}
finally
{
if ((cmd == null) == false)
{
cmd.Dispose();
cmd = null;
}
}
}
--------------------------------------------------

Any help would be appreciated 

Regards

Do you really need to return a cursor as output param? That might be the root of your problem. Wouldn't it be easier to just return the result set from the SP through a normal SELECT statement?

I dont see any obvious reason the code shouldnt work. 

If you execute the same procedure in sqlplus, as the same user,  using the same bind values, does the ref cursor return rows? Here's how you can test that, just in case you didnt already know. 

var P_SOURCE varchar2(50);
var P_BADGE_NBR varchar2(50);
var P_READ_FROM varchar2(50);
var P_READ_TO varchar2(50);
var rc refcursor;

begin
:P_SOURCE := '<insert value here>';
:P_BADGE_NBR := '<insert value here>';
:P_READ_FROM := '<insert value here>';
:P_READ_TO := '<insert value here>';
end;
/
set autoprint on
exec CM_EMR_GET_METER_READS(:P_SOURCE,:P_BADGE_NBR,:P_READ_FROM,:P_READ_TO,:RC);

 I have answered it here.

Hope it will help

http://forums.asp.net/t/1247854.aspx