sp_medicinesotckfind.sql

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

create or replace function sp_medicinesotckfind(l_medicineid in integer)
  return integer is
  l_medicinestockid integer;
begin
  select medicinestockid
  into   l_medicinestockid
  from   medicinestock
  where  medicineid = l_medicineid;
  return l_medicinestockid;
exception
  when others then
    return -1;
end;
/