Re: Create VIEW using Procedures

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