This discussion is archived
14 Replies Latest reply: Dec 12, 2012 5:41 AM by taimur RSS

Webutil form compilation error

taimur Newbie
Currently Being Moderated
Hi all

I configured webutil on Application server 10g on linux. but when i compile the demo form on application server using

/u01/app/oracle/OraHome_2/bin/frmcmp.sh module=$ORACLE_HOME/forms/WU_TEST_106.fmb userid=webutil/webutil@orant module_type=form compile_all=yes OUTPUT_FILE=$ORACLE_HOME/forms/WU_TEST_106.fmx

it give me the errors

FRM-18108: Failed to load the following objects.

Source Module:webutil.olb
Source Object: WEBUTIL
Compiling procedure GET_CLIENTINFO...
Compilation error on procedure GET_CLIENTINFO:
PL/SQL ERROR 201 at line 3, column 35
identifier 'WEBUTIL_CLIENTINFO.GET_USER_NAME' must be declared
PL/SQL ERROR 0 at line 3, column 3
Statement ignored
PL/SQL ERROR 201 at line 4, column 35
identifier 'WEBUTIL_CLIENTINFO.GET_IP_ADDRESS' must be declared
PL/SQL ERROR 0 at line 4, column 3
Statement ignored
.
.
..
.
..
.
.
Compilation errors have occurred.


Form not created
==========================================

i search a lot but failed ..

any solution regarding this plz thanks in advance.
  • 1. Re: Webutil form compilation error
    MLBrown Journeyer
    Currently Being Moderated
    Do you have the webutil.olb module in your $ORACLE_HOME/forms directory? If not, then put it there and try to compile again.
  • 2. Re: Webutil form compilation error
    vansul Pro
    Currently Being Moderated
    you have to add the webutil pll library and object to be drag and dropped to the form.
    You pll etc libraries should be available in the forms server directory.
  • 3. Re: Webutil form compilation error
    taimur Newbie
    Currently Being Moderated
    [oracle@appserver ~]$ ls -lh $ORACLE_HOME/forms
    total 3.7M
    drwx------ 4 oracle oinstall 4.0K Oct 30 2010 admin
    drwx------ 2 oracle oinstall 4.0K Oct 30 2010 api
    drwx------ 2 oracle oinstall 4.0K Oct 30 2010 config
    -rw------- 1 oracle oinstall 554 Oct 30 2010 converter.properties
    -rw-r--r-- 1 oracle oinstall 5.9K Dec 29 2004 create_webutil_db.sql
    drwx------ 3 oracle oinstall 4.0K Oct 30 2010 doc
    drwx------ 2 oracle oinstall 4.0K Oct 30 2010 em
    -rw------- 1 oracle oinstall 32K Oct 30 2010 EnableDisableItem.pll
    drwx------ 2 oracle oinstall 4.0K Oct 30 2010 j2ee
    drwx------ 8 oracle oinstall 4.0K Nov 20 17:19 java
    drwx------ 2 oracle oinstall 4.0K Oct 30 2010 lib
    drwx------ 2 oracle oinstall 4.0K Oct 30 2010 mesg
    drwx------ 2 oracle oinstall 4.0K Oct 30 2010 perl
    -rw------- 1 oracle oinstall 100K Oct 30 2010 rp2rro.pll
    -rw------- 1 oracle oinstall 9.6K Oct 30 2010 search_replace.properties
    drwx------ 2 oracle oinstall 4.0K Nov 20 18:23 server
    drwx------ 2 oracle oinstall 864K Nov 21 09:27 trace
    drwxr-xr-x 2 oracle oinstall 4.0K Nov 20 17:57 webutil
    -rw-r--r-- 1 oracle oinstall 884K May 6 2008 webutil_106.zip
    -rw-r--r-- 1 oracle oinstall 1.1M Feb 29 2012 webutil_lib.pll
    -rw-r--r-- 1 oracle oinstall 24K Aug 17 2005 webutil.olb
    -rw-r--r-- 1 oracle oinstall 468K Nov 20 17:25 webutil.plx
    -rw-r--r-- 1 oracle oinstall 144K Nov 20 16:41 WU_TEST_106.fmb
    [oracle@appserver ~]$

    webutil.olb is present in the $ORACLE_HOME/forms directory. also i compiled webutil.pll to generate .plx. its compiled successfully without any error.

    also my

    FORMS_PATH=/u01/app/oracle/OraHome_2/forms/;/u01/app/oracle/OraHome_2/forms/webutil/ in default.env
    CLASSPATH ( contains entries of frmwebutil.jar,jacob.jar and rt.jar).

    any suggestion please. is there any link that how i attached WEBUTIL TO my forms before compilation.
  • 4. Re: Webutil form compilation error
    mdra801108 Journeyer
    Currently Being Moderated
    Check this:

    http://www.oracle.com/technetwork/developer-tools/forms/readme-082817.html

    Also, did you run sql to create webutil package in db?

    Regards
  • 5. Re: Webutil form compilation error
    taimur Newbie
    Currently Being Moderated
    Yes i created the schema webutil/webutil and allow grants to public.

    also

    Run the script "create_webutil_db.sql for creating packages.
  • 6. Re: Webutil form compilation error
    mdra801108 Journeyer
    Currently Being Moderated
    Did you try to compile webutil from $ORACLE_HOME/forms folder?

    Regards

    Edited by: mdra801108 on Nov 20, 2012 11:52 PM

    Edited by: mdra801108 on Nov 21, 2012 12:06 AM
  • 7. Re: Webutil form compilation error
    taimur Newbie
    Currently Being Moderated
    [oracle@appserver ~]$ /u01/app/oracle/OraHome_2/bin/frmcmp_batch.sh module=$ORACLE_HOME/forms/webutil.pll userid=webutil/webutil@orant module_type=library compile_all=yes OUTPUT_FILE=$ORACLE_HOME/forms/webutil.plx
    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 11g Enterprise Edition Release 11.1.0.6.0 - Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing 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
    Compiling library WEBUTIL...
    Invalidating Package Spec CLIENT_IMAGE......
    Invalidating Package Spec CLIENT_OLE2......
    Invalidating Package Spec CLIENT_TEXT_IO......
    Invalidating Package Spec CLIENT_TOOL_ENV......
    Invalidating Package Spec CLIENT_WIN_API_DEBUG......
    Invalidating Package Spec CLIENT_WIN_API......
    Invalidating Package Spec CLIENT_WIN_API_ENVIRONMENT......
    Invalidating Package Spec CLIENT_WIN_API_PRELOAD......
    Invalidating Package Spec JAVA_EXCEPTION......
    Invalidating Package Spec WEBUTIL_BROWSER......
    Invalidating Package Spec WEBUTIL_CLIENTINFO......
    Invalidating Package Spec WEBUTIL_C_API......
    Invalidating Package Spec JAVA_SYSTEM......
    Invalidating Package Spec JAVA_APPSERV_READER......
    Invalidating Package Spec DELIMSTR......
    Invalidating Package Spec WEBUTIL_FILE......
    Invalidating Package Spec JAVA_APPSERV_WRITER......
    Invalidating Package Spec WEBUTIL_DB_LOCAL......
    Invalidating Package Spec JAVA_FILE......
    Invalidating Package Spec WEBUTIL_FILE_TRANSFER......
    Invalidating Package Spec WEBUTIL_HOST......
    Invalidating Package Spec WEBUTIL_SEPARATEFRAME......
    Invalidating Package Spec WEBUTIL_CORE......
    Invalidating Package Spec WEBUTIL_SESSION......
    Invalidating Package Spec WEBUTIL_UTIL......
    Invalidating Package Body WEBUTIL_UTIL......
    Invalidating Package Body WEBUTIL_SESSION......
    Invalidating Package Body WEBUTIL_SEPARATEFRAME......
    Invalidating Package Body WEBUTIL_HOST......
    Invalidating Package Body WEBUTIL_FILE_TRANSFER......
    Invalidating Package Body WEBUTIL_FILE......
    Invalidating Package Body WEBUTIL_DB_LOCAL......
    Invalidating Package Body WEBUTIL_C_API......
    Invalidating Package Body WEBUTIL_CORE......
    Invalidating Package Body WEBUTIL_CLIENTINFO......
    Invalidating Package Body WEBUTIL_BROWSER......
    Invalidating Procedure Body SHOW_WEBUTIL_INFORMATION......
    Invalidating Package Body JAVA_SYSTEM......
    Invalidating Package Body JAVA_FILE......
    Invalidating Package Body JAVA_EXCEPTION......
    Invalidating Package Body JAVA_APPSERV_WRITER......
    Invalidating Package Body JAVA_APPSERV_READER......
    Invalidating Package Body DELIMSTR......
    Invalidating Package Body CLIENT_WIN_API_PRELOAD......
    Invalidating Package Body CLIENT_WIN_API_ENVIRONMENT......
    Invalidating Package Body CLIENT_WIN_API_DEBUG......
    Invalidating Package Body CLIENT_WIN_API......
    Invalidating Package Body CLIENT_TOOL_ENV......
    Invalidating Package Body CLIENT_TEXT_IO......
    Invalidating Package Body CLIENT_OLE2......
    Invalidating Package Body CLIENT_IMAGE......
    Invalidating Procedure Body CLIENT_HOST......
    Invalidating Function Body CLIENT_GET_FILE_NAME......
    Compiling Package Spec CLIENT_IMAGE......
    Compiling Package Spec CLIENT_OLE2......
    Compiling Package Spec CLIENT_TEXT_IO......
    Compiling Package Spec CLIENT_TOOL_ENV......
    Compiling Package Spec CLIENT_WIN_API_DEBUG......
    Compiling Package Spec CLIENT_WIN_API......
    Compiling Package Spec CLIENT_WIN_API_ENVIRONMENT......
    Compiling Package Spec CLIENT_WIN_API_PRELOAD......
    Compiling Package Spec JAVA_EXCEPTION......
    Compiling Package Spec WEBUTIL_BROWSER......
    Compiling Package Spec WEBUTIL_CLIENTINFO......
    Compiling Package Spec JAVA_SYSTEM......
    Compiling Package Spec JAVA_APPSERV_READER......
    Compiling Package Spec DELIMSTR......
    Compiling Package Spec WEBUTIL_FILE......
    Compiling Package Spec JAVA_APPSERV_WRITER......
    Compiling Package Spec WEBUTIL_DB_LOCAL......
    Compiling Package Spec JAVA_FILE......
    Compiling Package Spec WEBUTIL_FILE_TRANSFER......
    Compiling Package Spec WEBUTIL_HOST......
    Compiling Package Spec WEBUTIL_SEPARATEFRAME......
    Compiling Package Spec WEBUTIL_CORE......
    Compiling Package Spec WEBUTIL_SESSION......
    Compiling Package Spec WEBUTIL_UTIL......
    Compiling Package Body WEBUTIL_UTIL......
    Compiling Package Body WEBUTIL_SESSION......
    Compiling Package Body WEBUTIL_SEPARATEFRAME......
    Compiling Package Body WEBUTIL_HOST......
    Compiling Package Body WEBUTIL_FILE_TRANSFER......
    Compiling Package Body WEBUTIL_FILE......
    Compiling Package Body WEBUTIL_DB_LOCAL......
    Compiling Package Body WEBUTIL_C_API......
    Compiling Package Body WEBUTIL_CORE......
    Compiling Package Body WEBUTIL_CLIENTINFO......
    Compiling Package Body WEBUTIL_BROWSER......
    Compiling Procedure Body SHOW_WEBUTIL_INFORMATION......
    Compiling Package Body JAVA_SYSTEM......
    Compiling Package Body JAVA_FILE......
    Compiling Package Body JAVA_EXCEPTION......
    Compiling Package Body JAVA_APPSERV_WRITER......
    Compiling Package Body JAVA_APPSERV_READER......
    Compiling Package Body DELIMSTR......
    Compiling Package Body CLIENT_WIN_API_PRELOAD......
    Compiling Package Body CLIENT_WIN_API_ENVIRONMENT......
    Compiling Package Body CLIENT_WIN_API_DEBUG......
    Compiling Package Body CLIENT_WIN_API......
    Compiling Package Body CLIENT_TOOL_ENV......
    Compiling Package Body CLIENT_TEXT_IO......
    Compiling Package Body CLIENT_OLE2......
    Compiling Package Body CLIENT_IMAGE......
    Compiling Procedure Body CLIENT_HOST......
    Compiling Function Body CLIENT_GET_FILE_NAME......
    Done.
    [oracle@appserver ~]$

    here is the code how i compile webutil.. its done sucessfully.
  • 8. Re: Webutil form compilation error
    mdra801108 Journeyer
    Currently Being Moderated
    Try this:

    1) Go to $ORACLE_HOME/forms folder


    2) Try this: /u01/app/oracle/OraHome_2/bin/frmcmp.sh module=WU_TEST_106.fmb userid=webutil/webutil@orant module_type=form compile_all=yes

    Regards
  • 9. Re: Webutil form compilation error
    taimur Newbie
    Currently Being Moderated
    [oracle@appserver forms]$ /u01/app/oracle/OraHome_2/bin/frmcmp.sh module=WU_TEST_106.fmb userid=webutil/webutil@orant module_type=form compile_all=yes
    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 11g Enterprise Edition Release 11.1.0.6.0 - Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing 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
    Compiling procedure GET_CLIENTINFO...
    Compilation error on procedure GET_CLIENTINFO:
    PL/SQL ERROR 201 at line 3, column 35
    identifier 'WEBUTIL_CLIENTINFO.GET_USER_NAME' must be declared
    PL/SQL ERROR 0 at line 3, column 3
    Statement ignored
    PL/SQL ERROR 201 at line 4, column 35
    identifier 'WEBUTIL_CLIENTINFO.GET_IP_ADDRESS' must be declared
    PL/SQL ERROR 0 at line 4, column 3
    Statement ignored
    PL/SQL ERROR 201 at line 5, column 35
    identifier 'WEBUTIL_CLIENTINFO.GET_HOST_NAME' must be declared
    PL/SQL ERROR 0 at line 5, column 3
    Statement ignored
    PL/SQL ERROR 201 at line 6, column 35
    identifier 'WEBUTIL_CLIENTINFO.GET_OPERATING_SYSTEM' must be declared
    PL/SQL ERROR 0 at line 6, column 3
    Statement ignored
    PL/SQL ERROR 201 at line 5, column 77
    identifier 'WEBUTIL_BROWSER.GETAPPLETPARAMETER' must be declared
    PL/SQL ERROR 0 at line 5, column 3
    Statement ignored
    PL/SQL ERROR 201 at line 6, column 85
    identifier 'WEBUTIL_BROWSER.GETAPPLETSIZE' must be declared
    PL/SQL ERROR 0 at line 6, column 3
    Statement ignored


    Compilation errors have occurred.


    Form not created
    [oracle@appserver forms]$
  • 10. Re: Webutil form compilation error
    mdra801108 Journeyer
    Currently Being Moderated
    Try to put webutil.pll in $ORACLE_HOME/forms folder.

    Regards
  • 11. Re: Webutil form compilation error
    Andreas Weiden Guru
    Currently Being Moderated
    Two ideas:

    Set the FORMS_PATH-env-variable to the same value as you have in your env-file before starting the compile.

    Another possible reason maybe case-sensitivity of the file name Webutil.pll. Try to remove and re-attach the webutil.pll from your form.
  • 12. Re: Webutil form compilation error
    taimur Newbie
    Currently Being Moderated
    i set FORMS_PATH variable to same as in default.env

    but error is the same..

    and plz can you elaborate the case sensitivity. because here are the pll , plx and olb name on $ORACLE_HOME/forms linux app server.

    -rwxrwxrwx 1 oracle oinstall 24K Aug 17 2005 webutil.olb
    -rwxrwxrwx 1 oracle oinstall 1.1M Feb 29 2012 webutil.pll
    -rwxrwxrwx 1 oracle oinstall 468K Nov 21 13:08 webutil.plx

    and i am creating forms in windows enviorment and attaching the same library that is provided with webutil_106.zip
  • 13. Re: Webutil form compilation error
    taimur Newbie
    Currently Being Moderated
    Problem solved after a long time.

    All the configurations are fine.only error is the environment variable at operating system level.i added these two variables in bash_profile.

    as fallow

    PATH=$ORACLE_HOME/bin:/u01/app/oracle/OraHome_2/jdk/bin:$ORACLE_HOME/forms:$PATH; export PATH
    FORMS_PATH=$ORACLE_HOME/forms:$ORACLE_HOME/forms/webutil; export FORMS_PATH
    CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

    after adding these compilation is fine.


    this may help any one.
  • 14. Re: Webutil form compilation error
    taimur Newbie
    Currently Being Moderated
    thanks you very much to all of you for your support

    Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points