用CoreLab.Oracle连接方式访问oracle的游标,得不到DataSet !
public bool RunProcedure(string ReturnParameter, CoreLab.Oracle.OracleDbType ParamType, ref DataSet Dataset, Hashtable HT, string ProcedureName)
{
CoreLab.Oracle.OracleConnection Connection =new CoreLab.Oracle.OracleConnection();
Connection.ConnectionString = this.DataAcc.OracleConnectionString;
Connection.Open();
CoreLab.Oracle.OracleCommand dacommand = new CoreLab.Oracle.OracleCommand();
dacommand.Connection = Connection;
dacommand.CommandType = CommandType.StoredProcedure;
IDictionaryEnumerator Enumerator;
Enumerator = HT.GetEnumerator();
object Value = null;
CoreLab.Oracle.OracleParameter OracleParam;
OracleParam = dacommand.Parameters.Add(new CoreLab.Oracle.OracleParameter(ReturnParameter, ParamType));
OracleParam.Direction = ParameterDirection.Output;
while (Enumerator.MoveNext())
{
Value = Enumerator.Value;
OracleParam = dacommand.Parameters.Add(new CoreLab.Oracle.OracleParameter(Enumerator.Key.ToString(), Value));
}
CoreLab.Oracle.OracleDataAdapter ODAdapter = new CoreLab.Oracle.OracleDataAdapter(dacommand);
try
{
ODAdapter.Fill(Dataset);
Close();
return true;
}
catch
{
Close();
return false;
}
finally
{
HT.Clear();
dacommand.Parameters.Clear();
}
}
此种方式在访问System.Data.OracleClient方式下访问就可以,为什么在CoreLab.Oracle方式的时候就没有返回记录!哪位给看看