Stored Procedures and Returning a Result Set (array) 
Author Message
 Stored Procedures and Returning a Result Set (array)
Hello,

Do Stored procedures support the return of multiple records yet array result
set?

Is so does anyone have a simple sample to include?

thanks



Mon, 01 Dec 2003 00:23:38 GMT
 Stored Procedures and Returning a Result Set (array)

Yes, you return it as a ref cursor.  Search metalink.oracle.com for ref
cursor and your specific language.

Regards,
Dave


Quote:
> Hello,

> Do Stored procedures support the return of multiple records yet array
result
> set?

> Is so does anyone have a simple sample to include?

> thanks



Mon, 01 Dec 2003 10:50:26 GMT
 Stored Procedures and Returning a Result Set (array)
You have to use a cursor...

--
Posted via dBforums, http://dbforums.com



Mon, 01 Dec 2003 18:10:49 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. returning result sets from stored procedures

2. Returning result sets in oracle stored procedure (OLEDB)

3. return multiple result sets from a stored procedure

4. Can't update result set returned from stored procedure using RDO

5. Returning result set from function to stored procedure is very slooooooooow

6. best way to return a paged result set from a stored procedure

7. Returning a result set from a Stored Procedure

8. returning result sets from stored procedures

9. How not to return multiple result sets from a stored procedure

10. Stored Procedure/Multiple Return Results/Set Statement

11. return result set from stored procedure

12. return result set from stored procedure


 
Powered by phpBB® Forum Software