how to return a record from pl/sql function

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 Mon Feb 10 2003 - 23:04:07 CET