I'm using Oracle 21c with Apex 24.2
I have a survey page that show one question at a time. When the user select an answer option the page submit the page and shoe the next question
Randomly (about the 40% of the time) I'm getting and ORA00001 error. The unique constraint violated is bases on two fields of the table that must be unique, beside the primary key which is an identity column
I checked before submit the page that no record have the same values.
For worst, when the error is raised, the Debug button turns inaccessible, so the only source of information is missing.
Anyone has any idea about how to handle this situation?
Thanks