请把忙看看这个存储过程为什么不对。
z3h 2005-03-17 10:42:05 今天刚开始写写存储过程,发现SQL%FOUND不起作用,如果查询不到数据,就出NO_DATA_FOUND异常。
CREATE OR REPLACE PROCEDURE KF_GETDQDM(
v_zjhm in varchar2,
v_bjhm in varchar2,
v_dqdm out varchar2
)
AS
i_dqdm varchar2(10);
BEGIN
select dqbh into i_dqdm
from power.KF_DQHDDBZ
where v_bjhm like bjdhhd||'%' and v_zjhm like zjdhhd||'%';
if not SQL%FOUND then
select dqbh into i_dqdm
from (
select dqbh from power.KF_DQHDDBZ
where v_bjhm like bjdhhd||'%'
order by xh
) where rownum=1;
if not SQL%FOUND then
v_dqdm:='000000';
else
v_dqdm:=i_dqdm;
end if;
else
v_dqdm:=i_dqdm;
end if;
END KF_GETDQDM;
/