关于c#调用oracle存储过程返回数据集的写法

CREATE OR REPLACE package body REPORT.Clinic_Rate
as
PROCEDURE Clinic_Master
(
    Start_Date date,
 End_Date date,
    I number,
    T_Rate  OUT T_CURSOR
)
IS
BEGIN
    OPEN T_Rate FOR
    select  COUNTS,count(*) as counts_number  from
    (
        SELECT PATIENT_ID,COUNT(PATIENT_ID) AS COUNTs FROM CLINIC_MASTER  WHERE visit_date>=Start_Date and Visit_date<=End_Date GROUP BY PATIENT_ID
    ) a
    group by COUNTS
    order by COUNTS;
END Clinic_Master;
end Clinic_Rate;
/

 

 

c#调用

 

private void Data_Load1()

    {

        OracleConnection newConn = MyConn.Conn_Oracle();

        newConn.Open();

        OracleCommand dmCmd = new OracleCommand("SXXX_SELDM_XML.dept_dict", newConn);        // 调用包中存储过程GetDM                        

        dmCmd.CommandType = CommandType.StoredProcedure;

 

        OracleParameter param_p_id = new OracleParameter("code", OracleType.Number);

        param_p_id.Direction = ParameterDirection.Input;

        param_p_id.Value = 148;

        OracleParameter param = new OracleParameter("C_DM_DEPT", OracleType.Cursor);

        param.Direction = ParameterDirection.Output;

        DataSet MyDataSet = new DataSet();

        dmCmd.Parameters.Add(param_p_id);

        dmCmd.Parameters.Add(param);

        OracleDataAdapter MyDataAdapter = new OracleDataAdapter();

        MyDataAdapter.SelectCommand = dmCmd;

        MyDataAdapter.Fill(MyDataSet, "Clinic_Data");

        GridView2.DataSource = MyDataSet.Tables["Clinic_Data"];

        GridView2.DataBind();

    }