Re: HELP....CURSORS

From: Ken Niedermeyer <kan9691_at_bcstec.ca.boeing.com>
Date: 1995/05/15
Message-ID: <D8MH00.DJo_at_bcstec.ca.boeing.com>#1/1

Try this:

DECLARE

	CURSOR a IS 	SELECT	column,
				column,
				....
			  FROM  table,
				table,
				...
			 WHERE	....;
	a_rec		a%ROWTYPE;

	CURSOR b IS	SELECT 	column,
                               	column, 
                               	.... 
                          FROM 	table, 
                               	table, 
                                ...      
                         WHERE  ....; 
        b_rec           b%ROWTYPE;

BEGIN OPEN a;
<process a>

CLOSE a;

OPEN b;
<process b>

CLOSE b;

-OR-

OPEN a;
<process a>

 OPEN b;
  <process b>
 CLOSE b;
CLOSE a;

END; I hope this helps.
The important thing is to declare any cursor you want to use within the same "scope" at the same time. If you want to just work on one cursor at a time the way you are currently doing it is just fine.

--

---
Ken Niedermeyer			| The views expressed above do not represent
Computing Systems Analyst	| those of my employer.... (but when do they?)
Boeing Computer Services (BCS)  | 
                                | NOTICE:
Internet:                       | Lack of planning on your part
kan9691_at_eeidf002.ca.boeing.com  | does not constitute an emergency on my part.

Received on Mon May 15 1995 - 00:00:00 CEST