Hi. Using version 19.2.
What I want: I have a page with a form that users have to fill (I used the form type but then deleted the default update process created by apex). When user click a confirm button I want to run a PL/SQL that updates/inserts 2 tables or shows error if some field is not filled right. If everything goes right I want to show success message. Some fields depend of other fields, so not easy to validate in client.
What I've tried:
I created a DA in button with 2 actions
1) Execute PL/SQL
2) Submit page
but I don't know how to stop submit if some error happens. Submit clears data entered by user -not user friendly- even though I have Reload on Submit to Only for Success. Isn't that supposed to avoid that?
So I tried to move PL/SQL to a Validation, but no luck with that.
I've been searching but I'm unable to find the solution (I wish there was a way to show only results less than 3 years old -rather not loose time seeing how things were done 12 years ago-).
What is the right way to do it?
Thanks.