begin for i in (select c001 "action", c002 "assigned_to" , c003 "root_cause_analysis" , c004 "status", c006 "question", n002 "id", n005 "score",d001 "completion_date" from APEX_COLLECTIONS where collection_name = 'CORRECTIVE_ACTIONS') LOOP iF i.id IS NULL THEN insert into ACTIONS ( ACTION, ASSIGNED_TO, COMPLETION_DATE,STATUS,REPORT_ID,ROOT_CAUSE_ANALYSIS ) values ( i.action, i.assigned_to, i.completion_date, i.status, :P41_REPORT_ID, i.root_cause_analysis); ELSE update ACTIONS set ACTION = i.action, ASSIGNED_TO = i.assigned_to, COMPLETION_DATE = i.completion_date, STATUS = i.status , REPORT_ID =:P41_REPORT_ID, ROOT_CAUSE_ANALYSIS = i.root_cause_analysis where ID = i.id; end if; END LOOP; end;