1 Reply Latest reply on Dec 8, 2008 2:27 AM by DanPaske

    Compilation error while generating the form in linux

    649608
      Hello everyone,

      I am using Oracle Designer ver10.1.2.4 in windows to generate the forms with standard object library ofgwebol.olb and template form ofgwebt.fmb. form (with both .fmb and .fmx files) are generated without errors. Also when I open the forms in separately they compiles without errors. But when I copy the same .fmb file into linux enviroment and compile it using frmcmp.sh userid=user/password@database module_type=form compile_all=yes module=form_name it gives following errors.

      $> frmcmp.sh userid=odin/odin@ontw10g module_ty
      pe=form compile_all=yes module=LOGIN_SCHERM
      Forms 10.1 (Form Compiler) Version 10.1.2.0.2 (Production)

      Forms 10.1 (Form Compiler): Release - Production

      Copyright (c) 1982, 2005, Oracle. All rights reserved.

      Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
      With the Partitioning, OLAP and Data Mining options
      PL/SQL Version 10.1.0.4.2 (Production)
      Oracle Procedure Builder V10.1.2.0.2 - Production
      Oracle Virtual Graphics System Version 10.1.2.0.0 (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
      FRM-18108: Failed to load the following objects.

      Source Module:ofgwebol.olb
      Source Object: CGSO$CHAR_DO
      Source Module:ofgwebol.olb
      Source Object: CGSO$CHAR_DO
      Source Module:ofgwebol.olb
      Source Object: CGSO$BLOCK
      Source Module:ofgwebol.olb
      Source Object: CGSO$CANVAS
      Source Module:ofgwebol.olb
      Source Object: CGSO$WINDOW
      Compiling function CGTE$CHECK_CONSTRAINT_VIO...
      No compilation errors.

      Compiling procedure CGTE$INLOGGEN_ERRORS...
      No compilation errors.
      L/SQL ERROR 0 at line 17, column 3
      Statement ignored
      PL/SQL ERROR 201 at line 36, column 3
      identifier 'CGNV$.NAV_CLOSE_FORMS' must be declared
      PL/SQL ERROR 0 at line 36, column 3
      Statement ignored
      PL/SQL ERROR 201 at line 37, column 3
      identifier 'CGNV$.NAV_OPENING_WND' must be declared
      PL/SQL ERROR 0 at line 37, column 3
      Statement ignored

      Compiling KEY-HELP trigger on form...
      No compilation errors.

      Compiling WHEN-WINDOW-ACTIVATED trigger on form...
      Compilation error on WHEN-WINDOW-ACTIVATED trigger on form:
      PL/SQL ERROR 201 at line 6, column 8
      identifier 'CGNV$GET_ITEM_WINDOW' must be declared
      PL/SQL ERROR 0 at line 4, column 3
      Statement ignored

      Compiling POST-TEXT-ITEM trigger on form...
      Compilation error on POST-TEXT-ITEM trigger on form:
      PL/SQL ERROR 201 at line 4, column 3
      identifier 'CGNV$.STORE_WND_ITEM' must be declared
      PL/SQL ERROR 0 at line 4, column 3
      Statement ignored

      Compiling WHEN-WINDOW-CLOSED trigger on form...
      Compilation error on WHEN-WINDOW-CLOSED trigger on form:
      PL/SQL ERROR 201 at line 5, column 3
      identifier 'CGNV$.TERMINATE_WINDOW' must be declared
      PL/SQL ERROR 0 at line 5, column 3
      Statement ignored

      Compiling WHEN-FORM-NAVIGATE trigger on form...
      Compilation error on WHEN-FORM-NAVIGATE trigger on form:
      PL/SQL ERROR 201 at line 3, column 3
      identifier 'CGNV$.REMOVE_CHILD_FORM' must be declared
      PL/SQL ERROR 0 at line 3, column 3
      Statement ignored

      Compiling KEY-EXIT trigger on form...
      Compilation error on KEY-EXIT trigger on form:
      PL/SQL ERROR 201 at line 5, column 3
      identifier 'CGNV$.NAV_ENTER_QUERY' must be declared
      PL/SQL ERROR 0 at line 5, column 3
      Statement ignored
      PL/SQL ERROR 201 at line 9, column 5
      identifier 'CGNV$.CLOSE_ALL_WINDOWS' must be declared
      PL/SQL ERROR 0 at line 9, column 5
      Statement ignored

      Compiling KEY-CLRFRM trigger on form...
      No compilation errors.

      Compiling ON-ERROR trigger on INLOGGEN data block...
      No compilation errors.

      Compiling KEY-PREV-ITEM trigger on AGB_ID item in INLOGGEN data block...
      Compilation error on KEY-PREV-ITEM trigger on AGB_ID item in INLOGGEN data block
      :
      PL/SQL ERROR 201 at line 4, column 3
      identifier 'CGNV$GO_PREV_ITEM' must be declared
      PL/SQL ERROR 0 at line 4, column 3
      Statement ignored

      Compiling KEY-NEXT-ITEM trigger on AGB_NAAM item in INLOGGEN data block...
      Compilation error on KEY-NEXT-ITEM trigger on AGB_NAAM item in INLOGGEN data blo
      ck:
      PL/SQL ERROR 201 at line 4, column 3
      identifier 'CGNV$GO_NEXT_ITEM' must be declared
      PL/SQL ERROR 0 at line 4, column 3
      Statement ignored


      Compilation errors have occurred.


      Form not created


      I think some standard library are missing in Linux environment. But I do not know the name of them and neither I can find. Please suggest the what need to be done to resolve the problem. The reason I am compiling the form in Linux is that I can run the form in windows because of corrupted installation of OC4j.

      Thanking you all much in advance.

      Edited by: Deepank on Dec 2, 2008 1:49 AM
        • 1. Re: Compilation error while generating the form in linux
          DanPaske
          Deepank-
          When generating forms from Designer, Designer attaches libraries - like ofgmes.pll, ofgnavl.pll, etc. You will need to copy these libraries to the same directory where your forms reside on your Linux box. To find out what libraries ate attached to your form, open it on your windows PC after generating it from Designer and you will see the attached libraries. Also, watch out for the case-sensitivity of Linux. If you have the Designer libraries on your linux box and you still get errors, try changing the case of the names of the libraries.

          Hope this helps,
          Dan