Issue in fetching data from SP(Oracle database)

See more:

C#

ASP

.NET

ADO.NET

Oracle

Hi All,

As I am new to this, I am facing some issue in executing stored procedure in oracle DB. Here is the SP which gives record as output parameter which is of type %rowtype and l_serno as input parameter which is of type Number.

Create OR Replace procedure get_product(l_serno in product.serno%type,record out product%rowtype)
is

begin

select * into record from product where serno=l_serno;

end get_product;

Using C#, I am trying to fetch the data from the SP and show it on the gridview.

OracleCommand cmd = new OracleCommand("get_product", Conn);
                cmd.CommandType = CommandType.StoredProcedure;
                Conn.Open();
                OracleParameter input = cmd.Parameters.Add("V_SERNO", OracleType.Number);
                OracleParameter output = cmd.Parameters.Add("ITEMS_CURSOR", OracleType.Cursor);
                input.Direction = ParameterDirection.Input;
                output.Direction = ParameterDirection.ReturnValue;
                input.Value = 2;
                OracleDataReader rd = cmd.ExecuteReader();
                DataTable dt = new DataTable();
                dt.Load(rd);
                GridView1.DataSource = dt;
                GridView1.DataBind();
                Conn.Close();
<pre/>
Here I am getting error as 

<pre lang="vb">ORA-06550: line 1, column 24:

PLS-00306: wrong number or types of arguments in call to 'GET_PRODUCT'

ORA-06550: line 1, column 7:

Please let me know what is the wrong I am doing here.
Thanks in Advance.