Make use of the built-in functions for Tables

Hi,

I'm not sure if I could do the following at all. I want to loop thru' the table of records to check if
1) it's the first record, then do something 2) it's the last record, then do something

CREATE OR REPLACE
PROCEDURE AS
first_entry_row new_scored_alm_leads_20061218%ROWTYPE := NULL; last_entry_row new_scored_alm_leads_20061218%ROWTYPE := NULL;

CURSOR c3 IS

          SELECT * FROM new_scored_alm_leads_20061218;

BEGIN

        FETCH C3.FIRST INTO first_entry_row
        FETCH C3.LAST INTO last_entry_row

			IF first_entry_row THEN
			 IF...

                                                 ELSE  N := N - 1 ;
			 END IF;



			ELSIF last_entry_row.Last THEN

			...
			END IF;

END LOOP;
END;
I ended up getting a bunch of error messages like the following. PLS-00225: subprogram or cursor 'C3' reference is out of scope

(THis program has been simplified dramatically to illustrate the problem)

Could someone tell me how to go around this problem? Received on Mon Dec 18 2006 - 18:14:07 CST