My Oracle Support Banner

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

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
Cause
Solution
References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.