I am trying to call a store procedure with output parameter as sys_refcursor through my C# code. But it is constinously giving me error saying "ORA-01036: illegal variable name/number"

See more:

C#

Oracle

I am trying to call a store procedure with output parameter as sys_refcursor through my C# code. But it is continuously giving me error saying "ORA-01036: illegal variable name/number"

I am using .NET framework 2.0 and System.Data.OracleClient for connecting Oracle database.

Is there anything that I am missing?

Thanks in advance

What I have tried:

I am writing here the C# and SP which I am using.

C# Code:

Public DataTable ExecuteReport(ReportFilters filterAttribute)
        {
            DataTable dtDetailedReport = new DataTable();
            using (OracleConnection conn = new OracleConnection())
            {
                conn.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
                OracleCommand cmd = new OracleCommand();
                cmd.Connection =conn;
                cmd.CommandText = "count_emp_by_dept";
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.Add("pin_no", OracleType.VarChar, 200).Value = filterAttribute.PIN;
                cmd.Parameters.Add("pResult ", OracleType.Cursor).Direction = ParameterDirection.Output;
                OracleDataAdapter adap =new OracleDataAdapter(cmd);
                adap.Fill(dtDetailedReport);
                conn.Close();
            }
            return dtDetailedReport;
        }

SP that I am using

Ceate or replace procedure count_emp_by_dept(pin_no Varchar2, pResult out sys_refcursor)
is
begin
  open pResult for 
 select pinname from TOC2_Test  where pin = pin_no;
end count_emp_by_dept;