Hi,
Does anybody know what the equivalent data type in C# is for an oracle NUMBER value? I have tried all that I can think and I keep getting an ORA-06650 error (wrong number or types of arguments in call to 'IFSAPP.SALES_PART_API.GET_LIST_PRICE').
Hope somebody can help!?Code:odc = new OleDbCommand(); odc.CommandText = "ifsapp.sales_part_api.get_list_price('" + sContract + "','" + sPartNo + "' )"; odc.CommandType = CommandType.StoredProcedure; odc.Connection = odbIFS; prm = new OleDbParameter("rv",OleDbType.Integer,25); prm.Direction = ParameterDirection.ReturnValue; odc.Parameters.Add(prm); prm = new OleDbParameter("contract_",OleDbType.VarChar,5); prm.Direction = ParameterDirection.Input; prm.Value = sContract; odc.Parameters.Add(prm); prm = new OleDbParameter("part_no_",OleDbType.VarChar,25); prm.Direction = ParameterDirection.Input; prm.Value = sPartNo; odc.Parameters.Add(prm); odc.ExecuteNonQuery();
Thanks,
DJ




