How to use Roll BAck and Commit transactions of SQL using uipath while doing bulk data insert

Help
1

Scenario: I have data 50 rows in excel. Need to insert all the row in SQL table. The Bot should insert either all 50 rows or none. If there is an exception with any single row of data then bot should not insert any data.

Please suggest how to use Rollback and commit transactions of SQL.

2

All I can say 4 years later is that if I end a piece of SQL with a “commit;” at the end, UiPath will complain about it this way:

Run command: ERROR [HY000] [Oracle][ODBC][Ora]ORA-00933: SQL command not properly ended