Hi,
I am quite new to APEX. I have following query.
I have following code on a button in APEX.
when I click on this button, I want to pop-up/messagebox
as "No employee found"
DECLARE
BEGIN
SELECT ename INTO V_ENAME
FROM EMP
WHERE 1 =2 ;
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.PUT_LINE('No emplyee found');
--I know we cannot use this way to show popup/messagebox
--but what is the alternative so that process show a popup/message.
END;
Can you please let me know how to implement this?