SET SERVEROUTPUT ON 
 
DECLARE 
n number; 
dst_addr varchar2(11); 
dat date; 
sdat date; 
attempt number; 
finaldate date; 
msgstate number; 
state varchar2(64); 
 
ref1 sys_refcursor; 
 
BEGIN 
ref1 := p_bs.f_getallStatus(sysdate-5,sysdate); 
 
LOOP 
FETCH ref1 INTO n, dst_addr, dat, sdat, attempt, finaldate, msgstate, state; 
EXIT WHEN ref1%NOTFOUND; 
dbms_output.put_line('n='||n||', msgstate='||TO_CHAR(msgstate)||', state='||state); 
END LOOP; 
 
CLOSE ref1; 
END;

           using (OracleConnection conn = new OracleConnection("data source=usa;user id=qwerty;password=ytrewq"))
            {
                try
                {
                    conn.Open();


                    OracleCommand cmd = new OracleCommand("p_bs.f_getallStatus", conn);
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Parameters.Add("@dateFrom", DateTime.Now.AddDays(-3)).Direction = ParameterDirection.Input;
                    cmd.Parameters.Add("@dateTo", DateTime.Now).Direction = ParameterDirection.Input;
                    OracleDataReader dr = cmd.ExecuteReader();

                    while (dr.Read())              
                        Console.WriteLine(string.Format("ID = {0}, Status = {1}", (string)dr["n"], (string)dr["msgstate"]));

                }
                catch (OracleException ex)
                {
                    return;
                }
                finally
                {
                    conn.Close();
                }
            }