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

Tim,

I haven't done this for a while, but can't you define a record type in the package and use that as the package-level data type rather than using the cursor type?
The function could copy fields from the cursor to the record a field at a time, but everywhere else would see it as a single variable (of a record type).

Sorry, no example and no real chance to try it!

Regds,

ETA (P.S., Hope this makes sense!)

"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 - 11:14:38 CET