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)?
No need to miss a message. Get email on-the-go
with Yahoo! Mail for Mobile. Get started.
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Feb 19 2007 - 01:06:26 CST
