Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to display messagebox in APEX

StarJan 31 2012 — edited Feb 1 2012
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?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 29 2012
Added on Jan 31 2012
5 comments
6,910 views