SV: Create VIEW using Procedures

I'm vorking with a application where we have lots of function calls in wiev select statements. It works fin almost always, but you should be careful to use functions in select statements, when working with large tables. Do not use functions calls in the where claus of selections. This can give wery bad performance i Oracle 7.3.4.x, workes pretty good in Oracle 7.2.3.x. I have not been working with Oracle 8, so I dont know how functions behave in it.

/Stefan

"Connor McDonald" <connor_mcdonald_at_yahoo.com> skrev i meddelandet news:38BCF883.4D7A_at_yahoo.com...
> Ali, Shahin wrote:
> >
> > Is there any way that a Procedure(parameters) can be called from a View.
> >
> > Many Thanks
> > Shahin.
>
> It wouldn't make a lot of sense to call a procedure from a view since
> each view column should be returning a value. You could include a
> PL/SQL function in a view along the lines of:
>
> create view my_view
> select col1, col2, my_plsql_function(col3) other_col
> from table;
> --
> ===========================================
> Connor McDonald
> http://www.oracledba.co.uk
>
> We are born naked, wet and hungry...then things get worse
Received on Wed Mar 01 2000 - 00:00:00 CST