Forum Stats

  • 3,872,115 Users
  • 2,266,381 Discussions
  • 7,911,051 Comments

Discussions

Oracle Apex alert message from PL/SQL

User_7IBR1
User_7IBR1 Member Posts: 2 Green Ribbon

Hi, I want to show alert message (popup message) when PL/SQL function returns N value. Now my PL/SQL code looks like this. I'm getting error in right corner, now I want to be popup message. Thanks.


declare 

x varchar2(1);

e_error exception;

BEGIN

x:=new_doc_admin.ZAH_READ_PCK.RightToEntery(:APP_USER,:P11_OSB_JMB);

IF x ='N' THEN

apex_util.set_session_state('P11_ERROR_MSG', 'No rights !');

         raise e_error;

END IF;              

END;

Answers