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

Are you looking for something like this ....

CREATE OR REPLACE PACKAGE "MYCPUCUR" AS TYPE aRecTyp IS RECORD (
datetime date,
valueavg float
);
[Quoted] 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;

• 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
  >
  >