oracle 为找到任何数据,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：未找到数据