 procedure refresh materialized view submit a job [message #124383] |
Fri, 17 June 2005 17:03  |
ekam
Messages: 1
Registered: June 2005
|
Junior Member |
|
|
I am trying to create a procedure that will refresh a materialized view and then submit a job which will fire off a few minutes later to run a report. I'm having a problem in that the mview gets refreshed and the job gets submitted but instead of just running once it goes into some kind of loop and tries to run several times. Both procedures work fine by themselves. My code is as follows:
create or replace procedure refresh_mv as
l_jobid number;
begin
dbms_mview.refresh('my_view','c');
dbms_job.submit(l_jobid, 'my_report', sysdate+1/1440, null);
commit;
end;
/
I believe it has something to do with the refresh but for the life of me I can't figure this one out. ANYONE?????
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
