给你一个简单例子,主要还是要靠自己 create or replace procdure (p_ID in varchar2, p_lRet out number) is v_ID integer; Begin SELECT count(*) INTO v_ID FROM tablename WHERE ID=p_ID; If v_ID=0 then P_lRet:=0; Return; End if; P_LRet:=1; Exception When others then P_LRet:= -1; End;
create or replace procdure
(p_ID in varchar2, p_lRet out number)
is
v_ID integer;
Begin
SELECT count(*) INTO v_ID FROM tablename
WHERE ID=p_ID;
If v_ID=0 then
P_lRet:=0;
Return;
End if;
P_LRet:=1;
Exception
When others then
P_LRet:= -1;
End;