Re: "RETURN" "WITH RESUME" in Oracle

As far as I now, there is not such a possibility in SPL. Regards. Amish Gandhi wrote: > Hi.. > > The problem I am facing is to use stored procedures in Oracle > to retrieve rows without involving temp table in the stored procedure. > > I have found a way to retrieve rows from a table in Informix using > stored > procedures without involving temp tables. > > I created a stored procedure that will read a row from the table and > pass it to the client and then continue reading for the next row.this > has been done using the RETURN statement WITH RESUME clause. > > I have then used an execute procedure scroll cursor in esqlc to run > this procedure and store the value into host variables. > > Is there an anologous "RETURN" "WITH RESUME" clause in Oracle? > > TIA. > > -Amish. -- - -------------------------------------------------------------- - - Arnaud ANDRIEUX arnaud.andrieux@aql.fr - - Ingenieur en developpement - - Direction Metier Industrie - - -------------------------------------------------------------- - - ALLIANCE QUALITE LOGICIEL http://www.aql.fr - - Rue de la Chataigneraie - - B.P. 127 - - 35513 CESSON SEVIGNE - - tel : (33) (0)2.99.12.50.00 - - fax : (33) (0)2.99.63.70.40 - - -------------------------------------------------------------- -