My Oracle Support Banner

Unable To Execute Coe_siebel_stats.sql (Doc ID 2637160.1)

Last updated on FEBRUARY 04, 2021

Applies to:

Siebel CRM - Version 18.9 and later
Information in this document applies to any platform.

Symptoms

 Customer unable to run coe_siebel_stats.sql

Changes

Customer ran coe_siebel_stats.sql with non-DBA or non-administrator level privileges resulting in following output and errors:

unable to execute the script and it is giving error:

Table created.

old 3: p_schema_owner IN VARCHAR2 DEFAULT '&&schema_owner.',
new 3: p_schema_owner IN VARCHAR2 DEFAULT '',
old 5: p_rows_threshold IN NUMBER DEFAULT &&default_rows_threshold.,
new 5: p_rows_threshold IN NUMBER DEFAULT 15,
old 10: p_schema_owner IN VARCHAR2 DEFAULT '&&schema_owner.',
new 10: p_schema_owner IN VARCHAR2 DEFAULT '',
old 12: p_rows_threshold IN NUMBER DEFAULT &&default_rows_threshold. );
new 12: p_rows_threshold IN NUMBER DEFAULT 15 );

Package created.

old 3: p_schema_owner IN VARCHAR2 DEFAULT '&&schema_owner.',
new 3: p_schema_owner IN VARCHAR2 DEFAULT '',
old 5: p_rows_threshold IN NUMBER DEFAULT &&default_rows_threshold.,
new 5: p_rows_threshold IN NUMBER DEFAULT 15,
old 42: l_schema_owner := UPPER(NVL(TRIM(' ' FROM p_schema_owner), '&&schema_owner.'));
new 42: l_schema_owner := UPPER(NVL(TRIM(' ' FROM p_schema_owner), ''));
old 56: l_rows_threshold := NVL(p_rows_threshold, &&default_rows_threshold.);
new 56: l_rows_threshold := NVL(p_rows_threshold, 15);
old 201: p_schema_owner IN VARCHAR2 DEFAULT '&&schema_owner.',
new 201: p_schema_owner IN VARCHAR2 DEFAULT '',
old 203: p_rows_threshold IN NUMBER DEFAULT &&default_rows_threshold. )
new 203: p_rows_threshold IN NUMBER DEFAULT 15 )

Warning: Package Body created with compilation errors.

Errors for PACKAGE BODY SIEBEL_STATS:

LINE/COL ERROR
-------- -----------------------------------------------------------------
27/7 PL/SQL: SQL Statement ignored
27/52 PL/SQL: ORA-00942: table or view does not exist
43/7 PL/SQL: SQL Statement ignored
43/41 PL/SQL: ORA-00942: table or view does not exist
70/15 PL/SQL: SQL Statement ignored
86/26 PL/SQL: ORA-00942: table or view does not exist
97/7 PL/SQL: Statement ignored
97/51 PLS-00364: loop index variable 'I' use is invalid
100/9 PL/SQL: Statement ignored
100/58 PLS-00364: loop index variable 'I' use is invalid
103/7 PL/SQL: Statement ignored

LINE/COL ERROR
-------- -----------------------------------------------------------------
103/10 PLS-00364: loop index variable 'I' use is invalid
GSBLDMRDEV1 ~$>

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!


In this Document
Symptoms
Changes
Cause
Solution
 Goal
References


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