--Rollback on Exception else Commit;

--SET TRANSACTION READ WRITE;

 BEGIN
  SAVEPOINT ABC;  
  update table_A set is_active ='Y' where config_id = 69;

  update table_A set createdon ='Y'  where config_id = 70; 

  EXCEPTION
  WHEN OTHERS THEN   
  ROLLBACK TO ABC;   
COMMIT;

END;


--createdon is of datetime type and has an exception. So rollback will happen.