oracle - How to catch a unique constraint error in a PL/SQL block?

Question

Say I have an Oracle PL/SQL block that inserts a record into a table and need to recover from a unique constraint error, like this:

begin
    insert into some_table ('some', 'values');
exception
    when ...
        update some_table set value = 'values' where key = 'some';
end;

Is it possible to replace the ellipsis for something in order to catch an unique constraint error?

question from:https://stackoverflow.com/questions/440135/how-to-catch-a-unique-constraint-error-in-a-pl-sql-block

Answer 1

EXCEPTION
      WHEN DUP_VAL_ON_INDEX
      THEN
         UPDATE