Re: View based on a procedure
- From: Mladen Gogala <mgogala@xxxxxxxxxxx>
- To: mark_ai@xxxxxxxxx
- Date: Mon, 19 Feb 2007 09:27:35 -0500
On 02/19/2007 02:06:26 AM, M. Alroy Mascrenghe wrote:
> Guys
> Is there a way to base a view/materialised view on a procedure? Everytime
> the view is selected from the procedure must be run. The procedure does a lot
> of heavy calculations writes to a table. And the view should read from that
> table. I know DML in select wont work. Is there a workaround, can use some
> other structure instead of a table in the procedure maybe like (varrays)?
>
You can create a pipelined procedure that returns PL/SQL table and then select
* from table(proc),
in a very similar fashion to select * from table(dbms_xplan.display);
--
Mladen Gogala
http://www.mladen-gogala.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
