首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > oracle >

ORA-01403:未找到数据,解决方法!

2014-01-28 
我的存储过程中如下: create or replace procedure SP_HJCL(wlsh in int, ls_datetime1 in varchar2, ls_da

我的存储过程中如下:
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:未找到数据         

热点排行