select taskid into v_parentid
from OA.T_PROJECTTASK
where LTrim(RTrim(wbs)) = v_wbs and submiter = p_userid and state='0';这句没有结果集,在oracle里会报错.可以改为:
select max(taskid) into v_parentid
from OA.T_PROJECTTASK
where LTrim(RTrim(wbs)) = v_wbs and submiter = p_userid and state='0';
from OA.T_PROJECTTASK
where LTrim(RTrim(wbs)) = v_wbs and submiter = p_userid and state='0';这句没有结果集,在oracle里会报错.可以改为:
select max(taskid) into v_parentid
from OA.T_PROJECTTASK
where LTrim(RTrim(wbs)) = v_wbs and submiter = p_userid and state='0';
exception
when no_data_found then
--这里写处理,如果没数据怎么处理,
when others then
null;
end;