Hi Team,
I have a Query as shown below but the messages is not displayed, only when i user RAISE_APPLICATION_ERROR then it got displayed but showing error code as well.
How to avoid error code please.
begin
lv_from_email_id := null;
select distinct email_address into lv_from_email_id from email_table where USER_INTRANET_ID=lower(:APP_USER);
exception when no_data_found then
apex_application.g_print_success_message := '<font size="7" color="green"> <b>User do not have access ';
end;
raise;
end;
(or)
begin
lv_from_email_id := null;
select distinct email_address into lv_from_email_id from email_table where USER_INTRANET_ID=lower(:APP_USER);
exception when no_data_found then
RAISE_APPLICATION_ERROR (-20020,'User do not have access');
raise;
end;
Regards,
Sruthitamiri