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: How to return array of values from procedure?

Re: How to return array of values from procedure?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Fri, 11 Jun 1999 17:16:45 GMT
Message-ID: <37684402.7200664@newshost.us.oracle.com>


A copy of this was sent to ggermann_at_dri.mcgraw-hill.com (Gabriele Germann/IN/FIS)
(if that email address didn't require changing) On Fri, 11 Jun 1999 04:08:47 -0800, you wrote:

>I noticed nobody ever answered your question. I am new at SQL too. Did you
>ever figure out the solution,
> or wether it is possible at all? I would be interested to know. Thanks.
>Gabriele
>
>

You can return cursor variables to return result sets.

You can return plsql tables (arrays of sorts) to various languages.

You can return varrays and nested table types with the Objects extensions in 8.0 and up.

>
> -**** Posted from RemarQ, http://www.remarq.com/?a ****-
> Search and Read Usenet Discussions in your Browser - FREE -

See http://www.oracle.com/ideveloper/ for my column 'Digging-in to Oracle8i'... Mirrored (and more current) at http://govt.us.oracle.com/~tkyte/

Current article is "Fine Grained Access Control", added June 8'th  

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 Fri Jun 11 1999 - 12:16:45 CDT

Original text of this message

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