| Simple procedure in OWB??? [message #311939] |
Mon, 07 April 2008 08:18  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
