Re: Returning SELECT output from PL/SQL proc/func

A copy of this was sent to "Steven D. Arnold" <stevena_at_permanent.cc> (if that email address didn't require changing) On Wed, 15 Sep 1999 03:44:30 GMT, you wrote:

>Hi,
>
>I know Transact-SQL and I am reading up on PL/SQL. I do not understand how
>a PL/SQL procedure or function can return a table of data -- for example, as
>from a SELECT statement -- to, say, an ODBC query. What I would like to do
>is something like this:
>
>Client application sends: "exec getAllPermissions()"
>Server responds with a table containing the PermissionID in the first
>column, the PermissionName in the second column and the
>PermissionDescription in the third column.
>
>Do I use DBMS_OUTPUT to display the results? If so, how do I delimit
>columns and rows? Do I return, say, a table of records from a function? I
>have been searching through the docs and it's difficult to find a direct
>answer to this question. Any hints?
>
>
>steve

see the URL in my signature -- there is a paper there that shows "howto" return a result set from a stored procedure.

-- 
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