Returning SELECT output from PL/SQL proc/func

[Quoted] 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 Received on Wed Sep 15 1999 - 05:44:30 CEST