The Best 3 Steps For Handling
Messages Oracle Forms
The Best 3 Steps For Handling
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,
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,
One of the most critical application concerns for a developer and for an end users is planning for handling application messages. Since, it reflects the quality of your code outputs is it buggy or it handles the end-users requirements effectively.
It is really embarrassing if you are in the presentation at your customer's company explaining your wonderful program and one of the unpleasant informative or error messages popes up at your customer's face. Well, it's not the end of your career life, you can manage this situation tactfully.
Let's limit the worries and start implementing a real reliable effective solution.
ask DefinitionT
Suppress Oracle Forms Informative & Error Messages
Task Solution:
Step One:
Create a database table for customizing your form errors as follow:
ask DefinitionT
Suppress Oracle Forms Informative & Error Messages
Task Solution:
Step One:
Create a database table for customizing your form errors as follow:
Step One:
Create a database table for customizing your form errors as follow:
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
; (
CREATE TABLE ERROR_MESSAGES),MSG_CODE NUMBER (5, 0) NOT NULL Primary Key,MSG_TYPE VARCHAR2 (1) NOT NULLMSG_DESC VARCHAR2 (200) NOT NULL; (
Step Two:
Run the following Ready Made English Messages Script as a sample data of such common Oracle Forms Informative and error messages.
Step Three:
Create On-Message and On-Error Triggers. Now, you paste the following optimized code into each trigger on form level with which you can handle the forms informative and error messages effectively.
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;
DECLARElv_errcod NUMBER := ERROR_CODE;
alert_message VARCHAR2 (200);BEGINSELECT msg_descINTO alert_messageFROM error_messagesWHERE msg_code = lv_errcod ;EXCEPTIONWHEN OTHERS THENalert_message:=message_type||'-'|| To_Char(message_code)|| ': ' || message_text;Raise Form_Trigger_failure;
END;
It's also a quite good idea to create a pl/sql library in oracle forms that includes a a procedure encapsulated in a pl/sql package with the previous code in order to facilitate reusing the optimized code as an object in each form application.
It's also a quite good idea to create a pl/sql library in oracle forms that includes a a procedure encapsulated in a pl/sql package with the previous code in order to facilitate reusing the optimized code as an object in each form application.
My success only comes from Allah, pls. note your comments and suggestions
are great help for me in progress thanks in advance.
My success only comes from Allah, pls. note your comments and suggestions
are great help for me in progress thanks in advance.
are great help for me in progress thanks in advance.
No comments :
Post a Comment