Re: Using cursor and PLSQL table

Kelvin Stingel wrote:

>I have filled a PL/SQL table with many values and now I want to
>feed these into a cursor.
>Im using 7.1 Oracle.
>Does anyone nknow how I can do this?

I don't really understand why you want to do this, so maybe I have the wrong end of the stick, but you can loop through the values in a table, using the binary integer key, and a no_data_found exception will be raised when you run out of values, so assuming the keys to your table start at one and are sequential, you can do something like:

count := 1;
BEGIN
    loop

• process table(count) count := count + 1; end loop; EXCEPTION when no_data_found then
• no more rows in table, finish processing END;