oracle双重游标,ORACLE创建多个游标并嵌套循环

ORACLE创建多个游标并嵌套循环

需求：每遍历游标2的记录时分别去遍历游标1的数据，并替换后插入临时表

CREATE OR REPLACE PROCEDURE TESTQ

IS

DownDictate VARCHAR2(200) DEFAULT '';

t_IsExist NUMBER:=0;

use_DownDictate VARCHAR2(200) DEFAULT '';

BEGIN

--判断指令是否会错误

SELECT DOWNDICTATE INTO DownDictate FROM T_MS_AUTOPLANDICTATE WHERE PROCEDURENAME='PKG_MEDI_IMM.QUERY_MEDI_IMM';

IF DownDictate IS NULL THEN

RETURN;

END IF;

--开始定义游标

DECLARE

---定义游标       1

CURSOR C_PARAMETERS IS

SELECT FUNCTIONNODECODE,FUNCTIONNODENAME FROM T_MS_FUNCTIONNODES WHERE FUNCTIONID =            (SELECT FUNCTIONID FROM T_MS_FUNCTION WHERE FUNCTIONPROCE='PKG_MEDI_IMM.QUERY_MEDI_IMM');

---定义游标          2

CURSOR C_MEDIIMME IS

SELECT * FROM (  SELECT              A.GRANTMASTER_BARCODE,A.GRANTMASTER_DAT