Re: Returning results from a Stored procedure

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Sun, 24 Oct 1999 19:41:19 -0400
Message-ID: <5ZgTOERnn5GTcf0jqq2HOorjz0zE@4ax.com>

A copy of this was sent to Pinne <pinne_at_pegit.se> (if that email address didn't require changing) On Sun, 24 Oct 1999 21:57:05 +0200, you wrote:

>Are these types of statement possible from within an SP:
>SELECT col1, col2 FROM Table1;
>?
>Ie. would it produce the same result as executing it from within SqlPlus
>
>SqlPlus gives me an error when i try to compile.
>Unless, i've cludged up the syntax. I doesn't seem possible.
>
>Is there another way to return result-sets from SP:s
>
>/Regards

See the URL in my signature. I have a short article on returning result sets from stored procedures (a HOWTO)

--
See http://osi.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 Sun Oct 24 1999 - 18:41:19 CDT