Re: Returning Resultsets from Procedures?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Mon, 09 Aug 1999 20:16:11 GMT
Message-ID: <37b936e9.29888717@newshost.us.oracle.com>

A copy of this was sent to me_at_nospam.com (if that email address didn't require changing) On Mon, 09 Aug 1999 17:23:17 GMT, you wrote:

>Can Oracle stored procedures return result sets? What I mean is
>can I do something like:
>
>create procedure getthem (tablname in varchar2)
>is begin
>select * from tablname;
>end;
>
>If yes how?
>
>TIA
>Selcuk

See the site in my .sig. There is an article there describing this. shows how to in sqlplus, proc, java and odbc.

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

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

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon Aug 09 1999 - 15:16:11 CDT