sp_medicinestockfindminsprice2.sql

来自「一整套的源代码」· SQL 代码 · 共 13 行

create or replace function sp_medicinestockfindminsprice2
(
  l_pstockmedicineid in integer
)
return number
is
  l_medicinestockid integer;
begin
  select medicinestockid into l_medicinestockid from pstockmedicine where pstockmedicineid = l_pstockmedicineid;
  return sp_medicinestockfindminsprice(l_medicinestockid);
end;
/