Re: calling functions in select

> 1)
> FOR lr_rec IN SELECT func(table.x, ...) FROM table,... WHERE ... LOOP
> END LOOP;
>
> 2)
> FOR lr_rec IN SELECT * FROM table,... WHERE ... LOOP
> li_x := func(lr_rec.x, ...);
> END LOOP;

i'll answer myself, it depends on whether func is iscachable or not,
right?

kuba