create or replace procedure Getmax(d1 in date,d2 in date, max out number) is
temp1 number;
d3 date;
cursor c1 is
select time,shuiwei from sys.kushui;
begin
open c1;
loop
fetch c1
into d3,temp1;
exit when c1%notfound;
dbms_output.put_line( 'kushui'
||temp1);
end loop;
close c1;
end Getmax;
测试的时候 发现运行错误,该怎么办呢,
出现符号">"在需要下列之一时:
(
temp1 number;
d3 date;
cursor c1 is
select time,shuiwei from sys.kushui;
begin
open c1;
loop
fetch c1
into d3,temp1;
exit when c1%notfound;
dbms_output.put_line( 'kushui'
||temp1);
end loop;
close c1;
end Getmax;
测试的时候 发现运行错误,该怎么办呢,
出现符号">"在需要下列之一时:
(
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货