create or replace function Scry_xk_qf_fz(nd in varchar2,xmid in varchar2) return number is cj number

这个 能编译，但是不能正常使用
这样正常应该返回 14 但是实际没有返回值 sql 下的输出的xmid 也不能显示

create or replace function Scry_xk_qf_fz(nd in varchar2,xmid in varchar2)
return number is
cj number;
begin
cj:=0;
select 23234 into cj from (select distinct (select count(*) from ( select * from SPPJ_SCAQJXKH a where gzqssjq=nd and (a.jlzt is null or a.jlzt <>'已删除') )
where fzr=(select xm from rygl_ryjl where id=xmid)) as fzp,(select count(*) from (select * from SPPJ_SCAQJXKH a where a.gzqssjq=nd and (a.jlzt is null or a.jlzt <>'已删除') )
where qfr=(select xm from rygl_ryjl where id=xmid)) as qfp,(select count(*)from (select * from SPPJ_SCAQJXKH a where a.gzqssjq=nd and (a.jlzt is null or a.jlzt <>'已删除') )
where xkr=(select xm from rygl_ryjl where id=xmid)) as xkp from ( select * from SPPJ_SCAQJXKH a where a.gzqssjq=nd and (a.jlzt is null or a.jlzt <>'已删除') ) kh );
dbms_output.put_line(xmid);
return cj;
end;

用plsql调试一下，看下是哪里写错了呗。

额