I have a question regarding a procedure that I'm doing oracle database. A little explanation for what I'm doing: I'm reading data from a table, and playing them on a cursor, after playing the cursor, I set it to a record, in the procedure I have 2 update and 10 inserts, in different tables. / p>
My question is the following, in case any of these procedures do something wrong, I give a rollback, in everything that has already been done. Is there any exception to oracle that I can handle this, for the updates and inserts and rollblack?