Oracle中,当向变量中插入数据时,如果查询到的数据为空,会报一个"ORA-01403:no data found"的的错误,这之后可以在插入数据之前先做一个判断,使用count获取查到的值得数量,如果为0,不去插入,不为0插入
CREATE OR REPLACE PROCEDURE "P_IS_PK"(v_p IN VARCHAR2,
cv_1 Out sys_refcursor
) As
vire varchar2(18);
temp number;
BEGIN
select count(1) into temp from ss WHERE aa=v_p
if temp > 0
then
select
aa
into vire
from ss
WHERE aa=v_p;
else
vire := v_p;
end if;
Open cv_1 For
select vire note from dual;
End;