Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Return a dataset from a stored procedure?
You wrote...
>
>The mechanism to do that is called "PL/SQL-Tables as IN/OUT-Parameters".
>A PL/SQL Table is a table like an ordinary Oracle Table. It can be used
>in stored procedures or functions as an IN/OUT Parameter. Inside the
>procedure or function you can select data with SELECT INTO etc. into the
>PL/SQL-Table and then pass in via OUT-Parameter to the caller of the
>function.
>
Again, as has been mentioned earlier, it is possible to return a result set via PL/SQL cursor variables under Oracle V7.3. See the PL/SQL V2.3 documentation for more information on cursor variables and how to return result sets through them.
Dave Macpherson Received on Thu Jul 03 1997 - 00:00:00 CDT