explore usage of SAVEPOINT to be able to rollback only partialy
Savepoint documentation:
https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_10001.htm#BABFIJGC
Rollback to a savepoint documentation:
https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9021.htm