My Oracle Support Banner

UTL_DBWS Package Not Installed in SYS by Default in Oracle Database 11g R2 (Doc ID 1268103.1)

Last updated on APRIL 12, 2018

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.

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

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.