create or replace procedure StatisticsRegion(
rs out Dataset.refcursor,
con out integer
)
is
begin
con := 0;
open rs for
select Region.Rname, count(Student.sno)
from Student, region
where Student.Rno = region.rno
group by Region.Rname;
select count(*)
into con
from student;
end StatisticsRegion;
/警告: 创建的过程带有编译错误。0/0 PL/SQL: Compilation unit analysis terminated
2/15 PLS-00201: 必须声明标识符 'DATASET.REFCURSOR'请问这是什么原因啊?
rs out Dataset.refcursor,
con out integer
)
is
begin
con := 0;
open rs for
select Region.Rname, count(Student.sno)
from Student, region
where Student.Rno = region.rno
group by Region.Rname;
select count(*)
into con
from student;
end StatisticsRegion;
/警告: 创建的过程带有编译错误。0/0 PL/SQL: Compilation unit analysis terminated
2/15 PLS-00201: 必须声明标识符 'DATASET.REFCURSOR'请问这是什么原因啊?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货