8 Replies Latest reply: Dec 27, 2013 1:15 AM by HamidHelal RSS

    What is the exact problem with this file?

    Vijetha

      Hi all,

       

      There is an old form , which was not in use from many days.

      Now when we tried to run the form, i got the error saying "FRM-40734:Internal Error:Pl/SQL error occured.", in the login form.

      When i tried to open the fmb file in Oracle Forms Builder 6i, i got the following error:

      FRM-10102: Cannot attach PL/SQL library d2kwutil. This library attachment will be lost if the module is saved., but the fmb file got open.

       

      The login button has the following code:

      DECLARE

        UNAME VARCHAR2(30);

        --USER_ID PARAMLIST;

        V_USER APUSERMA.USER_NAME%TYPE;

        V_PASSWED APUSERMA.USER_PASSWD%TYPE;

      BEGIN

      select user_CD INTO :GLOBAL.USER_ID from apuserma 

      where user_CD = :TI_USER_NAME AND user_PASSWD = :IT_USER_PASSWD

      AND SYSDATE BETWEEN USER_VALID_FRM AND USER_VALID_TO;

      :global.user_id  := substr(win_api_environment.read_registry('HKEY_LOCAL_MACHINE\system\currentcontrolset\control\computername\computername','computername'),1,10);

      :global.compname := :compname;

      compnm(:compname);

      --USER_ID := CREATE_PARAMETER_LIST('USER_id_NAME');

      call_form('Forms\MAIN_SCREEN',hide,DO_REPLACE);

      exception

        when no_data_found then

        MESSAGE('Incorrect Username or Password.  Please Re-Enter');

        message(' ');

        RAISE FORM_TRIGGER_FAILURE;

       

      END;

      EXIT_FORM;

      When i tried to compile, i got error saying ,

      Error 201 at line 10, column 28

      identifier 'WIN_API_ENVIRONMENT.READ_REGISTRY' must be declared.

      I am not getting to know What is the exact problem with this file?

      Help me with this please.

      Thank You.

       

      Oracle forms builder 6i.

      Oracle 9i.

        • 1. Re: What is the exact problem with this file?
          HamidHelal

          When i tried to open the fmb file in Oracle Forms Builder 6i, i got the following error:

          FRM-10102: Cannot attach PL/SQL library d2kwutil. This library attachment will be lost if the module is saved., but the fmb file got open.

          it has attached library d2kwutil. When you try to open the form, it didn't find the library in the <Builder 6i home>\FORMS60 folder.


          So, you can manually attach the library after opening the form or copy all required library at said location. Then open the form and it will automatically attach the library.


          if this done. Hope others problem will solve.


          Hamid

          • 2. Re: What is the exact problem with this file?
            Vijetha

            Actually now i got to know that there is no attached library in the form , that is in my system.

            Can you provide me a link where i can download  d2kwutil.pll for FORM ORACLE FORMS 6I.

            I tried to surf in the net , i'm not getting any link to download d2kwutil.pll

            let me know the link please for Windows Xp.

            • 3. Re: What is the exact problem with this file?
              HamidHelal

              Click Here to Download

               

              Hamid

              • 4. Re: What is the exact problem with this file?
                Vijetha

                I also want to know what is the use of  win_api_environment.read_registry('HKEY_LOCAL_MACHINE\system\currentcontrolset\control\computername\computername','computername') ??

                What does it do??

                If i comment the following line , will it be a problem??

                :global.user_id  := substr(win_api_environment.read_registry('HKEY_LOCAL_MACHINE\system\currentcontrolset\control\computername\computername','computername'),1,10);


                Because i commented the above line & compiled, so it is not giving any error now.

                So please tell me what win_api_environment.read_registry does??

                • 5. Re: What is the exact problem with this file?
                  Vijetha

                  Thank You Hamid.

                  But please let me know what does win_api_environment.read_registry do?

                  • 6. Re: What is the exact problem with this file?
                    HamidHelal

                    Vijetha wrote:

                     

                    I also want to know what is the use of  win_api_environment.read_registry('HKEY_LOCAL_MACHINE\system\currentcontrolset\control\computername\computername','computername') ??

                    What does it do??

                    If i comment the following line , will it be a problem??

                    :global.user_id  := substr(win_api_environment.read_registry('HKEY_LOCAL_MACHINE\system\currentcontrolset\control\computername\computername','computername'),1,10);


                    Because i commented the above line & compiled, so it is not giving any error now.

                    So please tell me what win_api_environment.read_registry does??

                    it's read windows registry value. So, no problem if you comment it.

                     

                    Thanks

                    • 7. Re: What is the exact problem with this file?
                      Vijetha

                      I attached d2kwutil.pll in the form & compiled it.

                      It got compiled.

                      But when i run the form , i got the following error:

                      FRM-40039: Cannot attach library d2kwutil while opening form 'FORM_NAME'.

                      • 8. Re: What is the exact problem with this file?
                        HamidHelal

                        open the d2kwutil.pll in form builder and compile .plx generated .


                        copy the bolh .pll and .plx to <Builder 6i home>\FORMS60 folder.


                        then try.