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

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Mon, 10 Feb 2003 15:04:16 -0800
Message-ID: <3E482FF0.49E4007E_at_exesolutions.com>


web guy wrote:

> 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

Then don't use a function ... use a stored procedure just set up a REF CURSOR as an OUT parameter.

Cross-post to c.d.o. removed.

Daniel Morgan Received on Tue Feb 11 2003 - 00:04:16 CET

Original text of this message