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;