create or replace procedure fx_gettext( nrid IN Integer,
names out string,
nrr out blob/*合同内容 varchar2*/
/*ri_Error out int*/
) is
icount number;
begin
icount :=2;
select count(*) into icount from fx_zt where id = nrid;
if icount =1 then select name,nr into names,nrr from fx_zt where id = nrid; end if;
/* IF sqlcode <> 0 then
ri_Error := 9999;
ELSE
ri_Error := 0;
end if;*/
end fx_gettext;
names out string,
nrr out blob/*合同内容 varchar2*/
/*ri_Error out int*/
) is
icount number;
begin
icount :=2;
select count(*) into icount from fx_zt where id = nrid;
if icount =1 then select name,nr into names,nrr from fx_zt where id = nrid; end if;
/* IF sqlcode <> 0 then
ri_Error := 9999;
ELSE
ri_Error := 0;
end if;*/
end fx_gettext;
select count(*) into icount from fx_zt where id = nrid;这条语句没有执行
我有这个数据但是查不到不知道什么原因
dbms_output.put_line(icount) 看看结果,就知道是否执行了没。