UTL_DBWS Package Not Installed in SYS by Default in Oracle Database 11g R2

(Doc ID 1268103.1)

Last updated on MARCH 15, 2017

Applies to:

Web Services - Version 10.1.3.4.0 to 10.1.3.4.0 [Release Oracle10g]
Information in this document applies to any platform.
***Checked for relevance on 09-Decl-2015***
Oracle Database 11g R2; dbws-callout-utility-10131.zip.


Symptoms

You may see the following errors when creating the function in Doc ID 841183.1 if the package was not installed:

LINE/COL ERROR
-------- -----------------------------------------------------------------
3/10 PL/SQL: Item ignored
3/10 PLS-00201: identifier 'SYS.UTL_DBWS' must be declared
4/7 PL/SQL: Item ignored
4/7 PLS-00201: identifier 'SYS.UTL_DBWS' must be declared
5/15 PL/SQL: Item ignored
5/15 PLS-00201: identifier 'SYS.UTL_DBWS' must be declared
6/12 PL/SQL: Item ignored
6/12 PLS-00201: identifier 'SYS.UTL_DBWS' must be declared
11/1 PL/SQL: Statement ignored
11/1 PLS-00201: identifier 'SYS.UTL_DBWS' must be declared
12/1 PL/SQL: Statement ignored

LINE/COL ERROR
-------- -----------------------------------------------------------------
12/1 PLS-00320: the declaration of the type of this expression is
incomplete or malformed

13/1 PL/SQL: Statement ignored
13/1 PLS-00320: the declaration of the type of this expression is
incomplete or malformed

14/1 PL/SQL: Statement ignored
14/1 PLS-00320: the declaration of the type of this expression is
incomplete or malformed

LINE/COL ERROR
-------- -----------------------------------------------------------------
15/1 PL/SQL: Statement ignored
15/42 PLS-00320: the declaration of the type of this expression is
incomplete or malformed

16/1 PL/SQL: Statement ignored
16/28 PLS-00320: the declaration of the type of this expression is
incomplete or malformed

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms