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!

How to display an error message in case of duplicate value in an IG ?

Christian PitetMar 2 2022

Hi,
I have an interactive grid with a column "ANNEE". It represents a year. I want this value to be unique in the IG when the user add a line. The table has a unique constraint on this column. I want to display a more-friendly error message than the error generated by SQL :
ORA-00001: violation de contrainte unique (SIVOA.PR_CONT_ECOLOGIQUE_DATE_UK1)
Best regards,
Christian

This post has been answered by Mudhaffer Al-Jabery on Mar 3 2022

Jump to Answer

Added on Mar 2 2022

#apex-discussions

22 comments

1,811 views

4 mentions