Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interactive Grid - Unique Key

partlycloudyOct 7 2018 — edited Jan 29 2019

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

Comments
Post Details
Added on Oct 7 2018
19 comments
5,229 views