Saved Message [message #445520] |
Tue, 02 March 2010 05:50  |
ghadeer
Messages: 25 Registered: February 2010 Location: ksa
|
Junior Member |
|
|
Hi All,
How can I remove (record asved) message that come automaticly
after commit??????
thanks
|
|
|
|
Re: Saved Message [message #445693 is a reply to message #445532] |
Wed, 03 March 2010 06:46   |
sts_sudha
Messages: 6 Registered: March 2010
|
Junior Member |
|
|
Hi,
There are two ways to do that.
1. On-Message
Right a form level trigger "on-message" and say null. But i would prefer not to do this, because after this, it may not throw any message at all, which is very essential.
2. You can set the message level to 25. and re-set it to 0.
Please try with 2nd approach and let me know your opinion.
Regards
Sudhakar T
|
|
|
|
Re: Saved Message [message #445707 is a reply to message #445693] |
Wed, 03 March 2010 07:18   |
cookiemonster
Messages: 13965 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
sts_sudha wrote on Wed, 03 March 2010 12:46
1. On-Message
Right a form level trigger "on-message" and say null. But i would prefer not to do this, because after this, it may not throw any message at all, which is very essential.
May? Will!
|
|
|
Re: Saved Message [message #445728 is a reply to message #445520] |
Wed, 03 March 2010 10:46  |
gregor
Messages: 86 Registered: March 2010 Location: Germany
|
Member |
|
|
Hi,
The best way is: ín the trigger "on-message" trap
the right Error_code ( for xx) ( Error_code /Error_typ are Forms-built-ins)
Pseudo-Code :
For Example: ON-ERROR trigger at the FORM level
DECLARE
errcode NUMBER(5) := ERROR_CODE;
errtype VARCHAR2(3) := ERROR_TYPE;
errtext VARCHAR2(78) := ERROR_TEXT;
BEGIN
/* To suppress the message use NULL, to change the message use */
/* the MESSAGE built-in to display your own text.
or better use "ALERT" built in */
IF errcode = 40401 THEN
MESSAGE('Your own message text');
ELSIF errcode = 40405 THEN
NULL;
ELSE
/* Leave all other messages unchanged */
-- You can use ALERT-built if you like /need a Message-Box
MESSAGE( errtype | | '-' | | TO_CHAR(errcode) | | ': ' | |errtext );
END IF;
END;
CM: added code tags, please do so yourself next time - see the orafaq forum guide if you're not sure how.
[Updated on: Wed, 03 March 2010 10:49] by Moderator Report message to a moderator
|
|
|