Oracle Apex alert message from PL/SQL

User_7IBR1

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;

Billy Verreynne

Do not raise an error, and simply pass the error message to the relevant page item.

Use the run Javascript dynamic action feature to run after the PL/SQL process, check if the error page item has a value and if so, use apex-message-namespace to display it.