8 Replies Latest reply on Dec 27, 2013 7:15 AM by HamidHelal

    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.