Home » Developer & Programmer » Warehouse Builder » Simple procedure in OWB??? (OWB 10.2.0.1)
Simple procedure in OWB??? [message #311939] Mon, 07 April 2008 08:18 Go to next message
olivierschumacher
Messages: 1
Registered: April 2008
Junior Member
Hi,

I'm fairly new to OWB and I was wondering where I could put a very simple procedure that refreshes a material view. Like EXECUTE DBMS_MVIEW.REFRESH('MV')
Since the MV doesn't refresh with 'ON COMMIT' because of some unions, is there some way to put the mentioned line of pl/sql code somewhere. I tried it in a procedure and put it at the end of the process flow but it didn't work. Didn't work in a pre/post mapping either. Maybe there's an other way alltogether.
Thanks in advance.
Re: Simple procedure in OWB??? [message #336933 is a reply to message #311939] Tue, 29 July 2008 07:12 Go to previous message
rado4377
Messages: 7
Registered: July 2008
Junior Member
Hi,
Alternative way is:
Create procedure say. sp_mv_refresh
and within this procedure you refresh the MV(s) and then import this procedure within the Transformations and include it in the process flow.

Regards




Previous Topic: Designing dimension/cubes using OWB
Next Topic: How to email mapping error message.
Goto Forum:
  


Current Time: Wed Apr 23 16:40:43 CDT 2014

Total time taken to generate the page: 0.08899 seconds