| 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.
|
|
|
]
Members
Search
Help
Register
Login
Home
