Subject Re: Stored Procedure vs View for derived/calculated data
Author Paco Zárate
[...
]> One interesting aspect (at least for me...:) that I encountered is
that
> with the CALC_ONE style, I expected to write something like :
> ...
> select mt.record_id, calc_one(mt.record_id)
> from myTable mt;
> ...
> which is very intuitive, but would not work....:)
>

Hi Sugi:
Hmmm maybe you could use the next construction:
select mt.record_id, (select somevalue from calc_value
(mt.record_id)) from myTable mt;

The "somevalue" field is the one that you put in the returns section
of the store procedure.

Regards
Paco Zarate