Re: how to return a record from pl/sql function

It is close. I "think" I want to use a function instead of a procedure, but does it matter? I'm going by what I've read, to use a function to return something to an Oracle Form.

If I create the type Record in the package header, what do I use as the RETURN entry for the function in the package body?

thx

"P Ethiraj" <pethiraj_at_hotmail.com> wrote in message news:b29t1c$25b$1_at_admin-svc.micron.com...
> Are you looking for something like this ....
>
> CREATE OR REPLACE PACKAGE "MYCPUCUR" AS
> TYPE aRecTyp IS RECORD (
> datetime date,
> valueavg float
> );
> TYPE aCurTyp IS REF CURSOR RETURN aRecTyp;
> END;
>
> CREATE OR REPLACE PROCEDURE "GET_CPU" (
> cv OUT MYCPUCUR.aCurTyp
> )
> AS
> BEGIN
> OPEN cv FOR
> SELECT
> LocalTimestamp AS TimeStamp
> ValueAvg As ValueAvg
> FROM
> MeasurementSummary ms;
> END;
>
> - Ethiraj
> "web guy" <web-guy01_at_attbi.com> wrote in message
> news:rlV1a.66158$vm2.37868_at_rwcrnsc54...
> > I have been successful returning a single value from a function, however
 I
> > now need to return a record and am having difficulties. I want my
 function
> > to be part of a package.
> >
> > I want the record to be a cursor record, because I only want to select
> > certain fields from a table, not the entire row.
> >
> > I can figure out what to put in as the return entry, when I don't
> > create the cursor record until after I define the cursor.
> >
> > Can anyone provide an example? I searched and I can't seem to
> > find one.
> >
> > Thanks.
> >
> > Tim
> >
> >
>
>
Received on Tue Feb 11 2003 - 14:20:25 CET