--Rollback on Exception else Commit;
    
    --SET TRANSACTION READ WRITE;
    
     BEGIN
      SAVEPOINT ABC;  
      update table_A set column1 ='Y' where id = 69;
    
      update table_A set column2 ='S'  where id = 70; 
    
      EXCEPTION
      WHEN OTHERS THEN   
      ROLLBACK TO ABC;   
    COMMIT;
    
    END;

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