Re: How can stored function return multiple rows?

A copy of this was sent to "John" <hanjenq_at_ms21.hinet.net> (if that email address didn't require changing) On Fri, 16 Apr 1999 17:02:19 +0800, you wrote:

>Hello!
> How can i use stored function to return multiple rows?
>

its called cursor variables.

see this link:

http://www.dejanews.com/[ST_rn=ps]/getdoc.xp?AN=465388583

(thats all one URL on that line) for an explaination of how to use cursor variables in sqlplus, pro*c, java, and odbc.

>Thanks
>
>Johnl
>hanjenq_at_ms21.hinet.net
>
 

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
http://govt.us.oracle.com/    -- downloadable utilities
 
----------------------------------------------------------------------------
Opinions are mine and do not necessarily reflect those of Oracle Corporation