My Oracle Support Banner

Gathering Table Stats Generates: "PLS-00302: Component 'TO_DEGREE_TYPE' Must Be Declared" Error (Doc ID 2061425.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


The following error is received while gathering table statistics:

Exception thrown starting activity.
Error preparing statement, closing statement or during callback execution. See underlying exception for details.
Error executing query.  sql=BEGIN DBMS_STATS.GATHER_TABLE_STATS('A','B', DEGREE => dbms_stats.to_degree_type(dbms_stats.get_prefs('DEGREE')), CASCADE => TRUE);END;.
ORA-06550: line 1, column 85:
PLS-00302: component 'TO_DEGREE_TYPE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored



 Upgraded recently to


To view full details, sign in with your My Oracle Support account.

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

In this Document

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