oracle将游标放入存储过程

最新推荐文章于 2024-10-30 09:13:50 发布

zhujiasi_192

最新推荐文章于 2024-10-30 09:13:50 发布

阅读量369

点赞数 1

文章标签： oracle 存储 exception integer insert c

本文链接：https://blog.csdn.net/zhujiasi_192/article/details/4742573

版权

create or replace procedure SP_TEST as
title1_value varchar2(30);
number1_value integer:=0;
CURSOR c_1 IS SELECT city_name,COUNT(city_name) FROM view_alarm_KZ1 GROUP BY city_name;
begin
open c_1;
LOOP
   FETCH c_1 INTO title1_value,number1_value;
   EXIT WHEN c_1%NOTFOUND;
   INSERT INTO TFA_ALARM_COUNTER_KZ(TITLE1,Collection_Time,Kz1) VALUES(title1_value,sysdate,number1_value);
END LOOP;
CLOSE c_1;
COMMIT;
EXCEPTION
WHEN OTHERS THEN
    ROLLBACK;
end;