Hello every one , I have one small question I am trying to run my procedure in anonymous block in a loop in that procedure some jobs are running .once that procedure executed again my job is running in same block .
I want to rollback my all the procedure changes when job in main transaction failed. Is this possible.Can we rollback job changes .
For example
declare
begin
begin
For i in 1..3
loop
savepoint abc;
Proc1();//calling a procedure which inside calling another job
end loop;
end;
sys.dbms_job ();//run a job then
if above sys job = 'faliled' // want to rollback my all procedure changes
rollback to ABC;
end if;
end;
Regards,
Sam