OraFAQ Forum: Forms » RAISE FORM_TRIGGER

Home » Developer & Programmer » Forms » RAISE FORM_TRIGGER_FAILURE NOT WORKING (ORACLE 11G)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

RAISE FORM_TRIGGER_FAILURE NOT WORKING [message #634949]

Wed, 18 March 2015 05:34

mehboob110233
Messages: 55
Registered: February 2014
Location: Pakistan

Member

Dear all
Here i face a problem with RAISE FORM_TRIGGER_FAILURE
i use it for break or raise the form but it not work properly can any one provide me idea about issue.

my coded here...

Quote:

IF :CONTACT_NO_MOB.PHONE_NUMBER IS NOT NULL THEN
IF LENGTH(:CONTACT_NO_MOB.PHONE_NUMBER) + LENGTH(:CONTACT_NO_MOB.PHONE_NUMBER) < 12 THEN
DISPLAY_ALERT('MESSAGE', 'Enter Valid Mobile No.');
RAISE FORM_TRIGGER_FAILURE;
END IF;
--CHECK MOBILE NUMBER LENGTH

Report message to a moderator

Re: RAISE FORM_TRIGGER_FAILURE NOT WORKING [message #634953 is a reply to message #634949]

Wed, 18 March 2015 06:08

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

BEGIN 
    IF :CONTACT_NO_MOB.phone_number IS NOT NULL THEN 
      IF Length(:CONTACT_NO_MOB.phone_number) < 12 THEN 
        Display_alert('MESSAGE', 'Enter Valid Mobile No.'); 
        RAISE form_trigger_failure; 
      END IF; 
   END   IF;
END;

[Updated on: Wed, 18 March 2015 06:17]

Report message to a moderator

Re: RAISE FORM_TRIGGER_FAILURE NOT WORKING [message #634960 is a reply to message #634953]

Wed, 18 March 2015 06:45

mehboob110233
Messages: 55
Registered: February 2014
Location: Pakistan

Member

Still not working...

Report message to a moderator

Re: RAISE FORM_TRIGGER_FAILURE NOT WORKING [message #634964 is a reply to message #634960]

Wed, 18 March 2015 07:50

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

What do you call "not working"? Is there any error? If so, which one? If it is not, what is it, then?

Report message to a moderator

Re: RAISE FORM_TRIGGER_FAILURE NOT WORKING [message #634973 is a reply to message #634949]

Wed, 18 March 2015 08:41

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

mehboob110233 wrote on Wed, 18 March 2015 06:34

Quote:

IF :CONTACT_NO_MOB.PHONE_NUMBER IS NOT NULL THEN
IF LENGTH(:CONTACT_NO_MOB.PHONE_NUMBER) + LENGTH(:CONTACT_NO_MOB.PHONE_NUMBER) < 12 THEN
DISPLAY_ALERT('MESSAGE', 'Enter Valid Mobile No.');
RAISE FORM_TRIGGER_FAILURE;
END IF;
--CHECK MOBILE NUMBER LENGTH

You are missing a second END IF;
Why are you adding the length of the phone number to itself? This is the same as multiplying it by 2.

Report message to a moderator

Previous Topic:	show message reshow window after update
Next Topic:	webutil_file_transfer

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 02:21:28 CDT 2024