plsql 语句ora_00103错误

declare
i integer;
n integer;
deviceid gxx01.sys_device.device_id%type;
regionid gxx01.sys_device.region_id%type;
devicename gxx01.sys_device.device_name%type;
devicetype gxx01.sys_device.device_type_id%type;
begin
for i in 1..100000
loop
select device_id, region_id,device_name,device_type_id into deviceid,regionid,devicename,devicetype from gxx01.sys_device;
for n in reverse (select count(*) from gxx01.sys_device)
loop
insert into rpt_history_data_201304(region_id,device_id,standard_id,signal_time,signal_value)
values (regionid,deviceid,'7188',to_date('2013-06-22 00:00:00','yyyy-mm-dd hh24-mi-ss')+i,'380');
end loop;
end loop;
commit;
end;
/
结果显示ora_00103错误，各位大侠帮忙

这个要是有多个结果，则INTO 会出错。
select device_id, region_id, device_name, device_type_id
into deviceid, regionid, devicename, devicetype
from gxx01.sys_device;
以下FOR 缺少一个范围，且你的变量N在后边的代码也没用到。
for n in reverse (select count(*) from gxx01.sys_device) loop　

应该直接说出你要做什么，大家才好帮你。

else if --> elsif salary||''||grade -->salary||''||to_char(grade) 改后这样: declare salary acount.acount%type; grade char(1); begin select acount into salary from acount where num=1; if salary >=1000 then grade:='a'; elsif salary >=800 then grade:='b'; else grade:='c'; end if; dbms_output.put_line(salary||''||to_char(grade)); exception when others then dbms_output.put_line(sqlerrm); end;

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息