比如:
CREATE OR REPLACE PROCEDURE ACC.DBP_REALCITYTRAFFICCNT IS
CURSOR cur1 IS SELECT --第一个游标
BEGIN
OPEN cur1 ;
LOOP
FETCH cur1 INTO
EXIT WHEN cur1%NOTFOUND;
...业务逻辑
COMMIT; END LOOP;
CLOSE cur1; EXCEPTION
WHEN OTHERS THEN
-- Consider logging the error and then re-raise
ROLLBACK;
RAISE; CURSOR cur2 IS SELECT --第二个游标
BEGIN
OPEN cur2 ;
LOOP
FETCH cur2 INTO
EXIT WHEN cur2%NOTFOUND;
...业务逻辑
COMMIT; END LOOP;
CLOSE cur2; EXCEPTION
WHEN OTHERS THEN
-- Consider logging the error and then re-raise
ROLLBACK;
RAISE;
END DBP_REALCITYTRAFFICCNT;
/
CREATE OR REPLACE PROCEDURE ACC.DBP_REALCITYTRAFFICCNT IS
CURSOR cur1 IS SELECT --第一个游标
BEGIN
OPEN cur1 ;
LOOP
FETCH cur1 INTO
EXIT WHEN cur1%NOTFOUND;
...业务逻辑
COMMIT; END LOOP;
CLOSE cur1; EXCEPTION
WHEN OTHERS THEN
-- Consider logging the error and then re-raise
ROLLBACK;
RAISE; CURSOR cur2 IS SELECT --第二个游标
BEGIN
OPEN cur2 ;
LOOP
FETCH cur2 INTO
EXIT WHEN cur2%NOTFOUND;
...业务逻辑
COMMIT; END LOOP;
CLOSE cur2; EXCEPTION
WHEN OTHERS THEN
-- Consider logging the error and then re-raise
ROLLBACK;
RAISE;
END DBP_REALCITYTRAFFICCNT;
/
解决方案 »
- 有点问题 请大家帮忙
- 请问有没有办法对指定用户设置Oracle的默认并行度(DOP,Degree of Parallel)?
- 向大家请教oracle olap 结果如何通过web展示
- oraclar 中 插入时间问题?
- logminer问题 ,,请大虾指教
- 请教:inner join 与 where子句有什么区别!
- 关于oracle触发器创建一问
- 在树形结构中,怎么样用一个SQL语句选出当前项的所有子项???
- 关于jsp写入oracle的clob字段的问题请高手帮忙解决一下,谢谢,
- SQL Plus 中,用 select * from table,显示太慢,1000多条就要跑上10多分钟,怎样修改显示速度?
- job上次未执行完,下次会执行吗
- SQL问题, 求高人
把第二个CURSOR cur2 IS SELECT --第二个游标
BEGIN
跟第一个一起放在申明的位置
CREATE OR REPLACE PROCEDURE ACC.DBP_REALCITYTRAFFICCNT IS
CURSOR cur1 IS SELECT ;
CURSOR cur2 IS SELECT ;
在去掉第二个begin
create or replace procedure pro_xx(in_date in date) as
type TCursor is ref cursor;
c1 TCursor;
c2 TCursor;
CURSOR cur1 IS SELECT --第一个游标CURSOR cur2 IS SELECT --第二个游标BEGIN
--调用cur1
BEGIN
OPEN cur1 ;
LOOP
FETCH cur1 INTO
EXIT WHEN cur1%NOTFOUND;
...业务逻辑
COMMIT; END LOOP;
CLOSE cur1;END;--调用cur2
BEGIN
OPEN cur2 ;
LOOP
FETCH cur2 INTO
EXIT WHEN cur2%NOTFOUND;
...业务逻辑
COMMIT; END LOOP;
CLOSE cur2;end;
END DBP_REALCITYTRAFFICCNT;