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.