Skip to Main Content
Forums

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!

Show alert from PL/SQL code

FC60Feb 21 2018 — edited Feb 22 2018

Hi,

I have this sequence of action to run.

  • I execute a select statement to verify if I can run an insert statement.
    • If I can, I run the insert and I show an alert for the user.
    • If I can't I want to show a second alert.

If I use a PL/SQL procedure, and I run it when I click a button, how can I have my alerts from the PL/SQL code (Somethink like APEX_ERROR.ADD_ERROR)? Or... Can I use a better solution?

Thanks.
This post has been answered by Sven W. on Feb 22 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 22 2018
Added on Feb 21 2018
#apex-discussions
7 comments
7,239 views