CREATE OR REPLACE PROCEDURE STWG.PRO_S_PM_EQUIP_CPU(
start_time IN date,EQUIP_NAME in varchar2(40)
)
IS
cpuused_now NUMBER;
cpuused_last NUMBER;
CPUUSED NUMBER;
BEGIN
select CPUUSED into cpuused_now from S_PM_EQUIP_CPU where to_char(starttime,'yyyy-mm-dd HH24:mi:ss')=start_time and EQUIPNAME=EQUIP_NAME;
select CPUUSED into cpuused_last from S_PM_EQUIP_CPU where to_char(starttime,'yyyy-mm-dd HH24:mi:ss')=start_time-30/1440 and EQUIPNAME=EQUIP_NAME;
CPUUSED:=cpuused_now-cpuused_last;
insert into ALARM_S_PM_EQUIP_CPU VALUES (start_time,start_time-30/1440,EQUIP_NAME,CPUUSED) ;
END;
END PRO_S_PM_EQUIP_CPU;报错,执行不了ORA-00900: invalid SQL statemet
EQUIPNAME STARTTIME CPUUSED
芥园道RNC-T600-2 2011-11-3 上午6:00:00 20
芥园道RNC-T600-2 2011-11-3 上午6:30:00 50
start_time IN date,EQUIP_NAME in varchar2(40)
)
IS
cpuused_now NUMBER;
cpuused_last NUMBER;
CPUUSED NUMBER;
BEGIN
select CPUUSED into cpuused_now from S_PM_EQUIP_CPU where to_char(starttime,'yyyy-mm-dd HH24:mi:ss')=start_time and EQUIPNAME=EQUIP_NAME;
select CPUUSED into cpuused_last from S_PM_EQUIP_CPU where to_char(starttime,'yyyy-mm-dd HH24:mi:ss')=start_time-30/1440 and EQUIPNAME=EQUIP_NAME;
CPUUSED:=cpuused_now-cpuused_last;
insert into ALARM_S_PM_EQUIP_CPU VALUES (start_time,start_time-30/1440,EQUIP_NAME,CPUUSED) ;
END;
END PRO_S_PM_EQUIP_CPU;报错,执行不了ORA-00900: invalid SQL statemet
EQUIPNAME STARTTIME CPUUSED
芥园道RNC-T600-2 2011-11-3 上午6:00:00 20
芥园道RNC-T600-2 2011-11-3 上午6:30:00 50
END PRO_S_PM_EQUIP_CPU;
----------两个end 是怎么回事?