string StrProceName = "P_GetDetailListByKeyWords";
            OracleParameter[] OParam ={
                                         new OracleParameter("in_Btime",OracleType.NVarChar,50),
                                         new OracleParameter("in_Etime",OracleType.NVarChar,50)，
                                         new OracleParameter("out_cursor",OracleType.Cursor)
                                     };
            OParam[0].Direction = ParameterDirection.Input;
            OParam[0].Value = StrBtime;
            OParam[1].Direction = ParameterDirection.Input;
            OParam[1].Value = StrEtime;
            OParam[3].Direction = ParameterDirection.Output;
            DataTable Dt = DbHelper.ExecuteProcDataTable(StrProceName, OParam);

        public static DataTable ExecuteProcDataTable(string storedProcName, OracleParameter[] parameters)
        {
            using (OracleConnection connection = new OracleConnection(connectionString))
            {
                DataTable dt = new DataTable();
                try
                {
                    connection.Open();
                    OracleDataAdapter sqlDA = new OracleDataAdapter();
                    sqlDA.SelectCommand = BuildQueryCommand(connection, storedProcName, parameters);
                    sqlDA.Fill(dt);
                }
                catch (Exception ex)
                {
                    throw ex;
                }
                finally
                {
                    connection.Close();
                }
                //connection.Close();
                return dt;
            }
        }

        private static OracleCommand BuildQueryCommand(OracleConnection connection, string storedProcName, OracleParameter[] parameters)
        {
            OracleCommand command = new OracleCommand(storedProcName, connection);
            command.CommandType = CommandType.StoredProcedure;
            foreach (OracleParameter parameter in parameters)
            {
                if (parameter != null)
                {
                    if ((parameter.Direction == ParameterDirection.InputOutput || parameter.Direction == ParameterDirection.Input) &&
                        (parameter.Value == null))
                    {
                        parameter.Value = DBNull.Value;
                    }
                    command.Parameters.Add(parameter);
                }
            }

            return command;
        }

CREATE OR REPLACE PROCEDURE getcounterresult(starttime IN DATE,
                                             endtime   IN DATE,
                                             res       OUT SYS_REFCURSOR) AS
BEGIN
  OPEN res FOR
    SELECT *
      FROM (SELECT SUM(xinding) AS xinding,
                   SUM(xuding) AS xuding,
                   SUM(tuiding) AS tuiding,
                   SUM(dianbo) AS dianbo,
                   SUM(tixing) AS tixing,
                   SUM(xindingprice) AS xindingprice,
                   SUM(xudingprice) AS xudingprice,
                   SUM(tuidingprice) AS tuidingprice,
                   SUM(dianboprice) AS dianboprice,
                   SUM(tixingprice) AS tixingprice,
                   SUM(price) AS price,
                   SUM(total) AS total,
                   1 AS id
              FROM (SELECT to_date(a.year || '-' || a.month || '-' || a.day,
                                   'yyyy-mm-dd') AS createtime,
                           SUM(nvl(decode(a.jllx, 1, a.total), 0)) AS xinding,
                           SUM(nvl(decode(a.jllx, 2, a.total), 0)) AS xuding,
                           SUM(nvl(decode(jllx, 3, a.total), 0)) AS tuiding,
                           SUM(nvl(decode(a.jllx, 4, a.total), 0)) AS dianbo,
                           SUM(nvl(decode(a.jllx, 5, a.total), 0)) AS tixing,
                           SUM(nvl(decode(a.jllx, 1, a.price), 0)) AS xindingprice,
                           SUM(nvl(decode(a.jllx, 2, a.price), 0)) AS xudingprice,
                           SUM(nvl(decode(jllx, 3, a.price), 0)) AS tuidingprice,
                           SUM(nvl(decode(a.jllx, 4, a.price), 0)) AS dianboprice,
                           SUM(nvl(decode(a.jllx, 5, a.price), 0)) AS tixingprice,
                           SUM(a.price) AS price,
                           SUM(a.total) AS total
                      FROM v$historyrecordforall a
                     WHERE to_date(a.year || '-' || a.month || '-' || a.day,
                                   'yyyy-mm-dd') BETWEEN
                           starttime AND
                           endtime
                     GROUP BY to_date(a.year || '-' || a.month || '-' ||
                                      a.day,
                                      'yyyy-mm-dd')
                     ORDER BY to_date(a.year || '-' || a.month || '-' ||
                                      a.day,
                                      'yyyy-mm-dd') DESC) v) v,
           
           (SELECT 1 AS id,
                   SUM(total) AS recordtotal,
                   SUM(dxjg) AS dxjg,
                   SUM(accept) AS accept,
                   SUM(send) AS send
              FROM sea_msg_v$daycount d
             WHERE to_date(d.year || '-' || d.month || '-' || d.day,
                           'yyyy-mm-dd') BETWEEN
                   starttime AND
                  endtime) r
     WHERE v.id = r.id;
END;

DECLARE
  paramstartime DATE := to_date('2012-01-01', 'yyyy-mm-dd');
  paramendtime  DATE := to_date('2012-12-30', 'yyyy-mm-dd');
  cur_res       SYS_REFCURSOR;
BEGIN
  getcounterresult(starttime => paramstartime,
                   endtime   => paramendtime,
                   res       => cur_res);
  FOR cur_next IN cur_res LOOP
    dbms_output.put_line(cur_next.xinding);
  END LOOP;
END;

declare
  out_cursor Sys_refcursor;
  emp_row tablename%rowtype;

begin
  p_test(Out_Cursor => out_cursor);
  loop
    fetch out_cursor
      into emp_row;
    if out_cursor%found then
      dbms_output.put_line(emp_row.fieldname);-- 这里不能写 *
    else
      exit;
    end if;
  end loop;
  close out_cursor;
end;