Hi Can some one help in writing a instead of trigger on this cursor so that i can update my view

Declare
cursor j1 is select min(jh.created_date) mindate, jh.job_id
from jobs@psn3 j, job_history jh, stages s
where s.system_stage_id=8 and
JH.JOB_ID=J.JOB_ID AND
JH.STAGE_ID=S.STAGE_ID group by jh.job_id;

Begin
for jobrdate in j1 loop
update v_jobs v
set returned_date = jobrdate.mindate
where v.job_id = jobrdate.job_id;
end loop;

COMMIT;

dbms_output.put_line('returned date has been update');

End;

Your help is much appreciated

Thank you