sp_servicefindprice.sql

一整套的源代码

create or replace function sp_servicefindprice
(
  l_serviceid in integer
)
return number
is
  l_count integer;
  l_price number(16, 4);
begin
  select count(*) into l_count from service where serviceid = l_serviceid;
  if l_count = 0 then
    return -1;
  end if;
  select charge into l_price from service where serviceid = l_serviceid;
  return l_price;
end;
/