Code: Select all
using (OracleConnection c = new OracleConnection(connString))
{
c.Open();
string commandQuery = @"select lpu.x.y(:pLid, :pRid) from dual";
using (OracleCommand cmd = new OracleCommand(commandQuery, c))
{
cmd.Parameters.Add("pLid", key.lid);
cmd.Parameters.Add("pRid", rid);
return Convert.ToDecimal(cmd.ExecuteScalar());
}
}