Home » Developer & Programmer » Forms » RAISE FORM_TRIGGER_FAILURE NOT WORKING (ORACLE 11G)
RAISE FORM_TRIGGER_FAILURE NOT WORKING [message #634949] Wed, 18 March 2015 05:34 Go to next message
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
Re: RAISE FORM_TRIGGER_FAILURE NOT WORKING [message #634953 is a reply to message #634949] Wed, 18 March 2015 06:08 Go to previous messageGo to next message
mist598
Messages: 1188
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 Go to previous messageGo to next message
mehboob110233
Messages: 55
Registered: February 2014
Location: Pakistan
Member

Still not working...
Re: RAISE FORM_TRIGGER_FAILURE NOT WORKING [message #634964 is a reply to message #634960] Wed, 18 March 2015 07:50 Go to previous messageGo to next message
Littlefoot
Messages: 21578
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?
Re: RAISE FORM_TRIGGER_FAILURE NOT WORKING [message #634973 is a reply to message #634949] Wed, 18 March 2015 08:41 Go to previous message
joy_division
Messages: 4949
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.
Previous Topic: show message reshow window after update
Next Topic: webutil_file_transfer
Goto Forum:
  


Current Time: Mon Aug 03 16:19:38 CDT 2020