https://apex.oracle.com/pls/apex/f?p=134181:39
IG on table defined as
create table ig_uk
(
pk integer generated always as identity primary key,
uk1 integer not null,
uk2 integer not null,
constraint ig_uk#uk unique (uk1,uk2),
val varchar2(100)
)
When the UK columns are updated to cause a duplicate, the Save button generates a database errorĀ Ajax call returned server error ORA-20987: APEX - ORA-00001: unique constraint violated error which is not very user friendly.
How can this be handled more gracefully?
Thanks