DUP_VAL_ON_INDEX

The DUP_VAL_ON_INDEX is raised when a SQL statement attempts to create a duplicate value in a column on which a unique index exists.


begin

insert into $table_name[...]

exception

when DUP_VAL_ON_INDEX then

update $table_name[...]

or...

dbms_output.put_line('Error');

end;