Popup the message on Oracle APEX based on the check oracle table

user_8192185 0
Viewed 260

Here is my scenario:

  1. Entering some values on the forms.

enter image description here

  1. On clicking Create, I want to check if the same data exists on the table.

  2. If exists, I want to popup the message as this value is already exists with Yes/No option.

  3. If the user clicking on Yes, then I wanted to Proceed the transaction which means I wanted to submit a page.

  4. If user selected No, then I wanted to STOP the transaction means I don't want to submit a page.

Please advise the solution to achieve the same.

oracle-apex-19.1 oracle-apex-5.1 oracle-apex oracle
1 Answers

This is the incorrect way for thinking about web technologies.

There's a significant time difference between 3 + 4, enough for another transaction to have occurred.

You should be applying constraints to the table, and responding to a key violation. At best, a warning could be present onChange of your item. But this should be re-validated on page submit.

user_5275130
Related