>Based upon my understanding, a cursor can only be looped through 1 record at a time, like a VB record set. I need the ability to run an SQL select statement over the cursor. Is this possible? If not, is there another solution.
>
>Thanks.

Oracle 8i support Temporary tables.

Mo