ORA-01403：未找到数据,解决方法!
点击右边红色标题查看本文完整版：ORA-01403：未找到数据,解决方法!
我的存储过程中如下：
create or replace procedure SP_HJCL(wlsh in int,
ls_datetime1 in varchar2,
ls_datetime2 in varchar2,
t_kcje out number)
as
t_sls number(20,8);
begin
select b.sls into t_sls from a_lldt a,a_lldd b
where a.lsh=b.lldtlsh and wzlsh=wlsh and a.djzt='2'
and to_char(zdsj,'yyyy-mm-dd hh24-mi-ss') between ls_datetime1 and ls_datetime2;
--select sls into t_sls from a_lldd where wzlsh=wlsh and lldtlsh in( select lsh from a_lldt
-- where djzt='2' and sls<0 and to_char(zdsj,'yyyy-mm-dd hh24-mi-ss') between ls_datetime1 and ls_datetime2);
if t_sls<0 then
select b.dj into t_kcje from a_zywzhjb a,a_gyckwzb b where a.wzlsh=b.lsh and wzlsh=wlsh
and a.hjsj=(select max(hjsj) from a_zywzhjb a,a_gyckwzb b where a.wzlsh=b.lsh and wzlsh=wlsh);
else
t_kcje:=0;
end if;
/*Exception
when value_error then
t_kcje:=-1;*/
end SP_HJCL;
错误是：ORA-01403：未找到数据
