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;
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:
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)