2 Replies Latest reply: Apr 2, 2013 3:00 AM by indra budiantho RSS

    FRM 41003 - the function cannot be perfomed here

    indra budiantho
      Forms [32 Bit] Version 10.1.2.0.2 (Production)
      Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
      Oracle Toolkit Version 10.1.2.0.2 (Production)
      PL/SQL Version 10.1.0.4.2 (Production)
      Oracle Procedure Builder V10.1.2.0.2 - Production
      PL/SQL Editor (c) WinMain Software (www.winmain.com), v1.0 (Production)
      Oracle Query Builder 10.1.2.0.2 - Production
      Oracle Virtual Graphics System Version 10.1.2.0.2 (Production)
      Oracle Tools GUI Utilities Version 10.1.2.0.2 (Production)
      Oracle Multimedia Version 10.1.2.0.2 (Production)
      Oracle Tools Integration Version 10.1.2.0.2 (Production)
      Oracle Tools Common Area Version 10.1.2.0.2
      Oracle CORE     10.1.0.4.0     Production

      hi there! I have a problem where i have on control with one button and when i click the button the trigger code is:
      DECLARE
      BEGIN
           IF :SYSTEM.MODE = 'NORMAL' THEN
                ENTER_QUERY;
           END IF;
           GO_BLOCK('PEGAWAI');
           EXECUTE_QUERY;
           
      END;
      in the table-based data block, i have a block named PEGWAI with item NAMA, it the pre-query trigger i put this criteria:
      :PEGAWAI.NAMA := 'ORA';
      Unfortunately, i got that error "FRM 41003 - the function cannot be perfomed here". What's wrong with my code, tx in advance.
        • 1. Re: FRM 41003 - the function cannot be perfomed here
          HamidHelal
          indra budiantho wrote:
          Forms [32 Bit] Version 10.1.2.0.2 (Production)
          Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
          Oracle Toolkit Version 10.1.2.0.2 (Production)
          PL/SQL Version 10.1.0.4.2 (Production)
          Oracle Procedure Builder V10.1.2.0.2 - Production
          PL/SQL Editor (c) WinMain Software (www.winmain.com), v1.0 (Production)
          Oracle Query Builder 10.1.2.0.2 - Production
          Oracle Virtual Graphics System Version 10.1.2.0.2 (Production)
          Oracle Tools GUI Utilities Version 10.1.2.0.2 (Production)
          Oracle Multimedia Version 10.1.2.0.2 (Production)
          Oracle Tools Integration Version 10.1.2.0.2 (Production)
          Oracle Tools Common Area Version 10.1.2.0.2
          Oracle CORE     10.1.0.4.0     Production

          hi there! I have a problem where i have on control with one button and when i click the button the trigger code is:
          DECLARE
          BEGIN
               IF :SYSTEM.MODE = 'NORMAL' THEN
                    ENTER_QUERY;
               END IF;
               GO_BLOCK('PEGAWAI');
               EXECUTE_QUERY;
               
          END;
          in the table-based data block, i have a block named PEGWAI with item NAMA, it the pre-query trigger i put this criteria:
          :PEGAWAI.NAMA := 'ORA';
          Unfortunately, i got that error "FRM 41003 - the function cannot be perfomed here". What's wrong with my code, tx in advance
          try the following code at when-button-press trigger
          DECLARE
          BEGIN
               IF :SYSTEM.MODE = 'NORMAL' THEN
                    ENTER_QUERY;
          
               END IF;
               GO_BLOCK('PEGAWAI');
          :PEGAWAI.NAMA := 'ORA';
               EXECUTE_QUERY;
               
          END;
          Hamid...

          Mark correct/helpful to help others to get right answer(s).*
          • 2. Re: FRM 41003 - the function cannot be perfomed here
            indra budiantho
            I got the solution, it is because there is no data and then i solve it using :System.Message_Level:
            DECLARE
            BEGIN
                 IF :SYSTEM.MODE = 'NORMAL' THEN
                      ENTER_QUERY;
                 END IF;
                      GO_BLOCK('PEGAWAI');
            :System.Message_Level := 25;
            
            EXECUTE_QUERY;
            :System.Message_Level := 0;     
            END;