Re: can a PL/SQL procedure return mul..

Isn't this a basic definition of a cursor? For example ---

DECLARE

     CURSOR C1 IS
            SELECT field1, field2 
            FROM   the_table
            WHERE  some_condition_statement;

     l_field1  VARCHAR2(10);
     l_field2  VARCHAR2(10);
BEGIN
     OPEN c1;
     LOOP
           FETCH c1 into l_field1, l_field2;
           exit when c1%notfound;

           (do something with each returned record)
     END LOOP;
     CLOSE c1;