Requirement is that data needs to be inserted into database table
through INSERT statement but the condition would be that,
if any one of the record is not loaded into the database table
no commit work is going to take place and rollback will take place.
only full data load of data is allowed no partial data load is allowed.
How to handle this after we write the INSERT statement.