Ora-06502: Pl/Sql: Numeric Or Value Error: Character String Buffer Too Small Creating Mview (Doc ID 1287014.1)

Last updated on JUNE 27, 2012

Applies to:

Oracle OLAP - Version 11.2.0.1 to 11.2.0.2 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 27-Jun-2012***

Symptoms

You receive the following error while creating Cube materialized view:

ORA-06502: PL/SQL: numeric or value error: character string buffer too small

Steps to Reproduce:

1 declare
2 salesaw varchar2(30);
3 begin
4 salesaw :=
5 dbms_cube.create_mview(
6 mvOwner =>'SH',
7 mvName =>'MV_BILLING_1',
8 sam_parameters=>'logDest=serverout,build=immediate,PARTITIONOPTION=NONE');
9* end;
SQL> /
SAM NOTE: Logging destination set to server output.
20101216 14:58:42.472 SAM NOTE: Begin cube xml template generation. Version: CF.
2009.01.16
20101216 14:58:42.472 SAM NOTE: Checking function argument.
20101216 14:58:42.472 SAM NOTE: Checking owner and materialized view name.
20101216 14:58:43.050 SAM NOTE: Identified ""SH"."BILLING"" as fact table o
f materialized view.
20101216 14:58:43.050 SAM NOTE: Setting package options.
SAM NOTE: Logging destination set to server output.
20101216 14:58:43.972 SAM NOTE: Rendering mode is loose.
20101216 14:58:44.097 SAM NOTE: Using default precompute percents "35:0".
20101216 14:58:44.097 SAM NOTE: Evaluating materialized view.
20101216 14:58:44.113 SAM NOTE: Checking for named views.
20101216 14:58:44.285 SAM NOTE: Checking for unsupported expressions.
20101216 14:58:44.316 SAM NOTE: Checking for cube consistant joins.
20101216 14:58:44.925 SAM NOTE: Checking for dimensions on materialized view ke
ys.
20101216 14:58:45.175 SAM NOTE: Checking aggregates.
20101216 14:58:45.285 SAM NOTE: Gathering model information.
20101216 14:58:47.050 SAM NOTE: Using composite key expression "SH"."ALL_TIM
E"."CALENDAR_YEAR"||'_'||"SH"."ALL_TIME"."CALENDAR_QUARTER"||'_'||"SH"."AL
L_TIME"."CALENDAR_MONTH" for cube dimension lowest level "ALL_TIME_D"."MONTH_L".
20101216 14:58:47.050 SAM NOTE: ERRBACKTRACE:
20101216 14:58:47.050 SAM NOTE: ORA-06502: PL/SQL: numeric or value error: chara
cter string buffer too small
ORA-06512: at "SYS.DBMS_CUBE", line 7699
ORA-06512:
at "SYS.DBMS_CUBE", line 7778
ORA-06512: at "SYS.DBMS_CUBE", line 8138
ORA-0651
2: at "SYS.DBMS_CUBE", line 8426
ORA-06512: at "SYS.DBMS_CUBE", line 8472
ORA-06
512: at "SYS.DBMS_CUBE", line 10049

20101216 14:58:47.066 SAM NOTE: ERRBACKTRACE:
20101216 14:58:47.066 SAM NOTE: ORA-06502: PL/SQL: numeric or value error: chara
cter string buffer too small
ORA-06512: at "SYS.DBMS_CUBE", line 10112
ORA-06512
: at "SYS.DBMS_CUBE", line 10212

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