3 Replies Latest reply: Mar 31, 2013 11:33 AM by O.Developer RSS

    what is raise form_trigger_failure

    salute-Salem
      db and dev 10g rel2
      hi all ,
      could you please tell me about the functionality of this statement ? what can i do with it ?


      i searched the online help , and i found just one page ,and got nothing from it , and there is nothing in the documentation .

      thanks in advance
        • 1. Re: what is raise form_trigger_failure
          Andreas Weiden
          RAISE raises an exception.
          FORM_TRIGGER_FAILURE is a forms-specific exception. if you raise it, it will stop the current processing without showing an error to the user. You use it e.g. in a WHEN-VALIDATE-ITEM-trigger when you want that the validation fails.

          Typos
          • 2. Re: what is raise form_trigger_failure
            HamidHelal
            newbi_egy wrote:
            db and dev 10g rel2
            hi all ,
            could you please tell me about the functionality of this statement ? what can i do with it ?


            i searched the online help , and i found just one page ,and got nothing from it , and there is nothing in the documentation .

            thanks in advance
            Hi egy
            Check this ..http://random-inspiration-blog.blogspot.com/2012/03/raise-formtriggerfailure-oracle.html

            Hope this helps
            • 3. Re: what is raise form_trigger_failure
              O.Developer
              Hi

              In a very basic and generic to explain 'Raise Form_Trigger_Failure' is , when you want to tell the end user that their input is not correct, use this statement. By using this statement oracle will not allow user further action.

              Hope you understood. If not the read the Forms 6I document which will be very help full - you can get it from below link simply
              https://drive.google.com/?tab=wo&authuser=0#my-drive


              newbi_egy wrote:
              db and dev 10g rel2
              hi all ,
              could you please tell me about the functionality of this statement ? what can i do with it ?


              i searched the online help , and i found just one page ,and got nothing from it , and there is nothing in the documentation .

              thanks in advance