Oracle plsql catching exceptions

Question

In a procedure I'm inserting values into different tables, whenever a unique/primary key violation occurs for a table, I want to handle the exception specifically for that table. How can I catch different duplicate value exceptions?

Answer 1

Check some tutorials like this.

Your unique/primary key violation will be a DUP_VAL_ON_INDEX exception.