Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Return a dataset from a stored procedure?

Re: Return a dataset from a stored procedure?

From: Dave Macpherson <dave_at_fifthd.ca>
Date: 1997/07/03
Message-ID: <33bbfbc6.7356842@news.sas.ab.ca>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US