Re: Stored procedures (HELP ME !!!)

> Jean-Marc ARZOUMANIAN <jmarzou_at_worlnet.fr> wrote:
>>Q: Does anyone know how to write an Oracle 7.x stored procedure that returns
>> a multiple result set ?
>A: nobody knows how to do this in Oracle7 because there is no such feature.
> best regards.
>Dave Mausner, Consulting Manager, Braun Technology Group, Chicago.

you can use REF CURSOR ( PL/SQL 2.2 ) in stored procedures and fetch from cursor in any client programs ( sql*plus).

bye

Suresh Yarlagadda Received on Mon Jul 22 1996 - 00:00:00 CEST