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 a recordset from PL/SQL FUNCTION

Re: how to return a recordset from PL/SQL FUNCTION

From: Epicentre team A <oracle_at_epicentre.fr>
Date: Thu, 5 Sep 2002 14:57:42 +0200
Message-ID: <al7k7n$qrt$1@wanadoo.fr>

create or replace package aa is

Type TQuantitesInfo IS RECORD

(

X NUMBER, Y NUMBER );

function t return TQuantitesInfo;

end;

/

create or replace package body aa;

create or replace function t is

e TQuantitesInfo

begin

e.X := 1;

e.Y := 2;

return e;

end;

end;

--
----------------------------------------------------------------------------
------------------------------
Très cordialement
Denis Jeanneret - Directeur Technique, Division ORACLE
Epicentre - 529 Route des Vernes 74370 PRINGY
Tel: 04.5009.7000
Fax:04.50.66.92.19
web: www.epicentre.fr
----------------------------------------------------------------------------
------------------------------




"Giovanni Azua" <bravegag_at_hotmail.com> wrote in message
news:al7298$1muk8k$1_at_ID-114658.news.dfncis.de...

> Hello all,
>
> I would like to find the way to return recordsets (or collection)
> from a PL/SQL function as the return parameter and read the
> results afterwards from a Java JDBC application.
>
> Can anyone point me to resources or information of how can this
> be done?
>
> Thanks in advance,
> Regards,
> Giovanni
> >
Received on Thu Sep 05 2002 - 07:57:42 CDT

Original text of this message

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