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

Last updated on FEBRUARY 13, 2024

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.