Re: PL/SQL - Returning resultset-like values from functions

Hi Sybrand,

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:411dlu0pjgjesb109a6dsialv9a2tbjoos_at_4ax.com...

> Nesting functions SELECTing from tables is a BAD idea. You will always
> get recursive sql as a result of that, the optimizer won't merge the
> two levels of sql into one.
> If you plan to go on this road you will create very inefficient
> applications.

Thanks for your help, but I'm afraid you got me wrong. This are'nt tables. It is more about returning "Structs". For example in a function I would like to do some calculation and to return a vector-struct which has no table representation in the database. Just a combination of basic types. Since I haven't used PL/SQL-Object yet I'm not experienced with Input/Output of objects.

> Also you can't return a resultset from a function you need a procedure
> with an IN OUT parameter of type REF CURSOR

This tip was helpful, too. Thanks.

--
Regards,
Carsten