PROMPT Template script for cleaning up corrupt data at seq level 9

DECLARE
   bug_no varchar2(8) := 'CKTEMP09';
BEGIN

  update ck_migration_objects set ci_created = 'N' where ci_stage = 'CKPREMIG' and ci_name = bug_no;

  -- PLACE YOUR SQL CODE TO CLEAN UP CORRUPT DATA HERE

  update ck_migration_objects set ci_created = 'Y' where ci_stage = 'CKPREMIG' and ci_name = bug_no;
   
  commit;
  
EXCEPTION 
  when others then
     dbms_output.put_line (' ** Exception Raised ** ');
     dbms_output.put_line ('...ERROR: '||substrb(sqlerrm, 1, 200));
     raise;
	 
end;
/
