ORA-06550: 第 1 行, 第 20 列: PLS-00302: 必须说明 'GET_FCDYBGWJJ_ZZ_GR' 组件 ORA-06550: 第 1 行, 第 7 列: PL/SQL: Statement ignored
PROCEDURE GET_FCDYBGWJJ_ZZ_GR(IN_BDATE DATE,IN_EDATE DATE,RET_CURSOR OUT MYCURSOR, ERRORCODE OUT INT) AS
BEGIN
ERRORCODE:=0; OPEN RET_CURSOR FOR
select
count(a.oinsid) as 件数,
nvl(sum(nvl(b.ttlarea,0)),0) as 建筑面积,
nvl(sum(hkval),0) as 抵押金额,
nvl(sum(nvl((select sum(nvl(drawmoney,0)) from i_sbcharge where oinsid=b.oinsid and stattype='登记费'),0)),0) as 登记费
from
i_optinst a,
fc_other b
where
a.oinsid=b.oinsid and
a.ostatus>=1 and
(a.soname='他项权利变更登记') and
(
((select buse from fc_room where roomid=(select roomid from fc_odetial where otherid=b.otherid and rownum=1))='住宅')
) and
a.sqlx='个人' and
a.aprldate between to_date(to_char(IN_BDATE,'yyyy-MM-dd'),'yyyy-MM-dd hh24:mi:ss') and to_date(to_char(IN_EDATE,'yyyy-MM-dd')||' 23:59:59','yyyy-MM-dd hh24:mi:ss');
EXCEPTION
WHEN NO_DATA_FOUND THEN ERRORCODE:=9999;
END GET_FCDYBGWJJ_ZZ_GR;
编译没有问题 但是执行取数据时 报ORA-06550错误
PROCEDURE GET_FCDYBGWJJ_ZZ_GR(IN_BDATE DATE,IN_EDATE DATE,RET_CURSOR OUT MYCURSOR, ERRORCODE OUT INT) AS
BEGIN
ERRORCODE:=0; OPEN RET_CURSOR FOR
select
count(a.oinsid) as 件数,
nvl(sum(nvl(b.ttlarea,0)),0) as 建筑面积,
nvl(sum(hkval),0) as 抵押金额,
nvl(sum(nvl((select sum(nvl(drawmoney,0)) from i_sbcharge where oinsid=b.oinsid and stattype='登记费'),0)),0) as 登记费
from
i_optinst a,
fc_other b
where
a.oinsid=b.oinsid and
a.ostatus>=1 and
(a.soname='他项权利变更登记') and
(
((select buse from fc_room where roomid=(select roomid from fc_odetial where otherid=b.otherid and rownum=1))='住宅')
) and
a.sqlx='个人' and
a.aprldate between to_date(to_char(IN_BDATE,'yyyy-MM-dd'),'yyyy-MM-dd hh24:mi:ss') and to_date(to_char(IN_EDATE,'yyyy-MM-dd')||' 23:59:59','yyyy-MM-dd hh24:mi:ss');
EXCEPTION
WHEN NO_DATA_FOUND THEN ERRORCODE:=9999;
END GET_FCDYBGWJJ_ZZ_GR;
编译没有问题 但是执行取数据时 报ORA-06550错误
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货