oracle数据库创建存储过程
oracle数据库创建存储过程,
根据有传入数据,有输出数据的操作例子
CREATE OR REPLACE
PROCEDURE happyPro (sfz IN VARCHAR2, bz OUT VARCHAR2)
AS
v_nums NUMBER;
v_sfzs varchar2(50);
BEGIN
v_sfzs:=sfz;
select count(*) into v_nums from (select b.empiid from happytable a
INNER JOIN hopetable b on a.ID=b.MMID
where a.signflag='1' and b.mmid=v_sfzs and a.ENDDATE>(select sysdate from dual));
if(v_nums>0) then
bz:='Y';
ELSE
bz:='N';
end if;
END;