Nesting cursors
- From: Thomas Day <tomday2@xxxxxxxxx>
- To: Oracle Mailing List <ORACLE-L@xxxxxxxxxxxxx>
- Date: Tue, 18 Oct 2005 11:49:51 -0400
Maybe what I'm trying to do isn't legal in PL/SQL. In any case, the
documentation that I've read hasn't been helpful. So far the general form of
what I've written is:
PROCEDURE AAA IS
CURSOR (collect events);
BEGIN
FOR EVENTRECORD IN EVENTS(EVENT_ID) LOOP --loop 1
DECLARE
CURSOR A (collect A facts);
CURSOR B (collect B facts);
CURSOR C (collect C facts);
BEGIN
FOR ARECORD IN A(fact_id) LOOP -- loop 2
build an output array based on ARECORD;
END LOOP; -- loop 2
END;
BEGIN
FOR EVENTRECORD IN EVENTS(EVENT_ID) LOOP --loop 3
CURSOR D (collect D facts);
--build an output array trying to coorelate B, C, and D facts (if there' s
no cooreleation then B and C are null)
OPEN CURSOR B and test for coorelation; CLOSE CURSOR B;
OPEN CURSOR C and test for coorelation; CLOSE CURSOR C:
build an output array based on DRECORD correlated with B & C;
END LOOP; --loop3
END;
END LOOP; -- loop 1
END;
The errors that I'm getting are from
OPEN CURSOR B and test for coorelation; CLOSE CURSOR B;
OPEN CURSOR C and test for coorelation; CLOSE CURSOR C:
The errors that I'm getting are on the OPEN CURSOR B (and C) and CLOSE.
PLS-00201: identifier 'B' must be declared
PLS-00201: identifier 'C' must be declared
Can anyone see what I'm doing wrong? I've tried adding extra DECLAREs but
that hasn't done the trick.
Other related posts:
