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

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
Messages: 7
Registered: July 2008
Junior Member
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.


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

Current Time: Wed Mar 29 11:22:43 CDT 2023