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

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

>
>