Forum Stats

  • 3,722,791 Users
  • 2,244,415 Discussions
  • 7,850,094 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

issue compiling webutil liabrary in 12c

Tony007
Tony007 Member Posts: 4,046 Bronze Trophy

hi am having this error when compiling webutil in 12c

Forms 12 (Form Compiler) Version 12.2.1.4.0 (Production)


Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.


Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

PL/SQL Version 12.1.0.2.0 (Production)

Oracle Procedure Builder V12.2.1.4.0 - Production

Oracle Virtual Graphics System Version 12.2.1.4.0 (Production)

Oracle Multimedia Version 12.2.1.4.0 (Production)

Oracle Tools Integration Version 12.2.1.4.0 (Production)

Oracle Tools Common Area Version 12.2.1.4.0

Oracle CORE   12.1.0.2.0   Production

Compiling library WEBUTIL...

 Invalidating Package Spec WEBUTIL_FILE_TRANSFER......

 Invalidating Package Spec WEBUTIL_FILE......

 Invalidating Package Spec WEBUTIL_DB_LOCAL......

 Invalidating Package Spec CLIENT_WIN_API......

 Invalidating Package Spec CLIENT_IMAGE......

 Invalidating Package Spec CLIENT_OLE2......

 Invalidating Package Spec CLIENT_TEXT_IO......

 Invalidating Package Spec CLIENT_WIN_API_ENVIRONMENT......

 Invalidating Package Spec CLIENT_TOOL_ENV......

 Invalidating Package Spec CLIENT_WIN_API_DEBUG......

 Invalidating Package Spec CLIENT_WIN_API_PRELOAD......

 Invalidating Package Spec DELIMSTR......

 Invalidating Package Spec JAVA_APPSERV_READER......

 Invalidating Package Spec JAVA_APPSERV_WRITER......

 Invalidating Package Spec JAVA_EXCEPTION......

 Invalidating Package Spec JAVA_FILE......

 Invalidating Package Spec JAVA_SYSTEM......

 Invalidating Package Spec WEBUTIL_BROWSER......

 Invalidating Package Spec WEBUTIL_CLIENTINFO......

 Invalidating Package Spec WEBUTIL_C_API......

 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 WEBUTIL_FILE_TRANSFER......

 Compiling Package Spec WEBUTIL_FILE......

 Compiling Package Spec WEBUTIL_DB_LOCAL......

 Compiling Package Spec CLIENT_WIN_API......

 Compiling Package Spec CLIENT_IMAGE......

 Compiling Package Spec CLIENT_OLE2......

 Compiling Package Spec CLIENT_TEXT_IO......

 Compiling Package Spec CLIENT_WIN_API_ENVIRONMENT......

 Compiling Package Spec CLIENT_TOOL_ENV......

 Compiling Package Spec CLIENT_WIN_API_DEBUG......

 Compiling Package Spec CLIENT_WIN_API_PRELOAD......

 Compiling Package Spec DELIMSTR......

 Compiling Package Spec JAVA_APPSERV_READER......

 Compiling Package Spec JAVA_APPSERV_WRITER......

 Compiling Package Spec JAVA_EXCEPTION......

 Compiling Package Spec JAVA_FILE......

 Compiling Package Spec JAVA_SYSTEM......

 Compiling Package Spec WEBUTIL_BROWSER......

 Compiling Package Spec WEBUTIL_CLIENTINFO......

 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......

ERROR 201 at line 9, column 12

 identifier 'WEBUTIL_DB.OPENBLOB' must be declared

ERROR 0 at line 9, column 5

 Statement ignored

ERROR 201 at line 18, column 12

 identifier 'WEBUTIL_DB.CLOSEBLOB' must be declared

ERROR 0 at line 18, column 5

 Statement ignored

ERROR 201 at line 24, column 5

 identifier 'WEBUTIL_DB.WRITEDATA' must be declared

ERROR 0 at line 24, column 5

 Statement ignored

ERROR 201 at line 29, column 12

 identifier 'WEBUTIL_DB.READDATA' must be declared

ERROR 0 at line 29, column 5

 Statement ignored

ERROR 201 at line 35, column 12

 identifier 'WEBUTIL_DB.GETLASTERROR' must be declared

ERROR 0 at line 35, column 5

 Statement ignored

ERROR 201 at line 40, column 12

 identifier 'WEBUTIL_DB.GETSOURCELENGTH' must be declared

ERROR 0 at line 40, column 5

 Statement ignored

ERROR 201 at line 45, column 12

 identifier 'WEBUTIL_DB.GETSOURCECHUNKS' must be declared

ERROR 0 at line 45, column 5

 Statement ignored

 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......

Closing library WEBUTIL...

Compilation errors on WEBUTIL_DB_LOCAL:

PL/SQL ERROR 201 at line 9, column 12

identifier 'WEBUTIL_DB.OPENBLOB' must be declared

PL/SQL ERROR 0 at line 9, column 5

Statement ignored

PL/SQL ERROR 201 at line 18, column 12

identifier 'WEBUTIL_DB.CLOSEBLOB' must be declared

PL/SQL ERROR 0 at line 18, column 5

Statement ignored

PL/SQL ERROR 201 at line 24, column 5

identifier 'WEBUTIL_DB.WRITEDATA' must be declared

PL/SQL ERROR 0 at line 24, column 5

Statement ignored

PL/SQL ERROR 201 at line 29, column 12

identifier 'WEBUTIL_DB.READDATA' must be declared

PL/SQL ERROR 0 at line 29, column 5

Statement ignored

PL/SQL ERROR 201 at line 35, column 12

identifier 'WEBUTIL_DB.GETLASTERROR' must be declared

PL/SQL ERROR 0 at line 35, column 5

Statement ignored

PL/SQL ERROR 201 at line 40, column 12

identifier 'WEBUTIL_DB.GETSOURCELENGTH' must be declared

PL/SQL ERROR 0 at line 40, column 5

Statement ignored

PL/SQL ERROR 201 at line 45, column 12

identifier 'WEBUTIL_DB.GETSOURCECHUNKS' must be declared

PL/SQL ERROR 0 at line 45, column 5

Statement ignored


Failed to generate library.


FRM-30312: Failed to compile the library.


-----------------------------STEP 1 EXECUTED-----------------------------

 EXECUTABLE_FILE Process failed...

-----------------------------STEP 2 FAILED-----------------------------

i did this

SQL> conn / as sysdba

Connected.

SQL> create public synonym webutil_db for webutil.webutil_db;

Synonym created.

SQL> grant execute on webutil_db to public;

Grant succeeded.

SQL> revoke connect,resource from webutil;

Revoke succeeded.

Answers

  • Michael Ferrante-Oracle
    Michael Ferrante-Oracle Member Posts: 6,490 Employee

    You have not installed the needed database objects needed by WebUtil. You must run create_webutil_db.sql before generating the library and/or your Forms to which it is attached. Because these objects will need to be accessible by all users, it is recommended that you run the script using a unique scheme (e.g. "webutil") and grant access to all user. The script can be found in the OracleHome\forms directory.

    This information is explained in the Builder Help. Here is a snippet of that text:


  • Tony007
    Tony007 Member Posts: 4,046 Bronze Trophy
    edited April 2

    i did that


    SQL> GRANT CREATE any procedure TO webutil;


    Grant succeeded.


    SQL> commit;


    Commit complete.


    SQL> @create_webutil_db.sql


    Package created.



    Package body created.


    Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

    Version 19.5.0.0.0

    bash-4.4$ sqlplus "/as sysdba"


    SQL*Plus: Release 19.0.0.0.0 - Production on Wed Mar 31 15:38:48 2021

    Version 19.5.0.0.0


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



    Connected to:

    Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

    Version 19.5.0.0.0


    SQL> create public synonym webutil_db for webutil.webutil_db;


    Synonym created.


    SQL> commit;


    Commit complete.


    SQL> grant execute on webutil_db to public;


    Grant succeeded.


    SQL> commit;


    Commit complete.


    SQL> revoke connect,resource from webutil;

    revoke connect,resource from webutil

    *

    ERROR at line 1:

    ORA-01951: ROLE 'RESOURCE' not granted to 'WEBUTIL'



    SQL> revoke connect from webutil;


    Revoke succeeded.


    SQL> commit;


    Commit complete.


    SQL> grant execute on webutil_db to public;


    Grant succeeded.


    SQL> commit;


    Commit complete.

    i did this also

    grant execute on dbms_lob webutil


    grant execute on UTL_RAW to webutil


    grant execute on UTL_ENCODE to webutil

  • Michael Ferrante-Oracle
    Michael Ferrante-Oracle Member Posts: 6,490 Employee

    Well you likely have some kind of permissions issue. I would recommend not revoking anything until you have verified that things are working.

  • Tony007
    Tony007 Member Posts: 4,046 Bronze Trophy

    which permission

  • Michael Ferrante-Oracle
    Michael Ferrante-Oracle Member Posts: 6,490 Employee

    ?? You granted "webutil" connect and resource then revoked them. Why? All I'm saying is that before revoking anything you should first verify that things are working correctly.

    You shared this:

    ....
    SQL> revoke connect,resource from webutil;
    revoke connect,resource from webutil
    *
    ERROR at line 1:
    ORA-01951: ROLE 'RESOURCE' not granted to 'WEBUTIL'
    SQL> revoke connect from webutil;
    Revoke succeeded.
    


  • Tony007
    Tony007 Member Posts: 4,046 Bronze Trophy

    i did grant again


    grant resource to webutil;


    Grant succeeded.


    SQL> grant connect to webutil;


    Grant succeeded.

  • Tony007
    Tony007 Member Posts: 4,046 Bronze Trophy

    i connect with webutil user it compile but fail with other user

Sign In or Register to comment.