Re: arrays in pl/sql

you could use the table of type
ie

/* variable declarations below */

cursor_exists boolean;
variable_incrementer binary_integer;

table_format is table of table_name%rowtype index by binary_integer;

table_data table_foramt;

down in your cursor----

cursor cursor_1 is

            select tablename.*
            from tablename;

begin
          open cursor_1;
          cursor_Exists := true;
          while cursor_exists = true 
          loop
                 fetch cursor_1 into table_data(variable_incrementer);
                 if cursor_1%notfound then
                     cursor_exists := false;
                 else
                         /* other code */
                 end if;
         end loop;
         close cursor_1;