Saturday, May 9, 2015

Best 3 Steps To Suppress Messages Oracle Forms

 The Best 3 Steps To Suppress
Messages Oracle Forms 



In the name of Allah, Most Gracious, Most Merciful

Praise be to Allah, blessing and peace be upon our prophet Mohammed, his family and his companions. After that,

Introduction


     In fact, start learning oracle forms must be confronted with some problems as any programming language. You may find yourself desperate, .stressed and  unable to move forward smoothly
This is really embarrassing especially when the dead line of your application delivery is getting closer.
  
No worries, it's normal. Many error messages pop-up at run-time since you are new to this working programming language environment. But, forms needs you to realize the way to output your required tasks the way you expect.  you didn't handle them properly as expected. 

     Eventually, the following optimized technique is the best practice i successfully used not only to oblige the application end-users to input valid data, but also to save more wasted time and effort early before testing and maintaining stages.


ask DefinitionT   
         
    
  Suppress Errors & Informative Oracle Forms Messages


Task Solution:

    

Pls follow the following three steps:


Step One: 


Create a table for customizing Form Errors


CREATE TABLE ERROR_MESSAGES
)
,MSG_CODE NUMBER (5, 0) NOT NULL Primary Key 
,MSG_TYPE VARCHAR2 (1) NOT NULL 
MSG_DESC VARCHAR2 (200) NOT NULL
; ( 


Step Two:


Run the Following Ready English Script 


     The above link is just a sample data of  such Oracle Form error & informative messages into the above table created in step one.


Step Three:


Create On-Message and On-Error Triggers  



DECLARE
       lv_errcod NUMBER  := ERROR_CODE;    
       alert_message          VARCHAR2 (200);
  BEGIN
         SELECT msg_desc
         INTO     alert_message
         FROM   error_messages
         WHERE msg_code = lv_errcod ;
 EXCEPTION
         WHEN OTHERS THEN
       alert_message:=message_type||'-'|| To_Char(message_code)
 || ': ' ||  message_text;
 Raise Form_Trigger_failure;    
  END;

 

Conclusion: 

       You can make a full benefit of the three steps as:

  1.  Create a table to build a database to your form errors.
  2.   Run the following most common customized informative and error messages of The Oracle Forms.
  3. Create an On-Error & On-Message triggers Form-Level to call the customized messages just in need. 




Hope this helps…



My success only comes from Allah, pls. note your comments and suggestions 
are great help for me in progress thanks in advance.