Database Upgrade to 12.1.0.2 Fails with Error:"ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind" (Doc ID 2173880.1)

Last updated on JUNE 16, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Database Upgrade to 12.1.0.2 fails when utlmmig.sql is executed during upgrade process with following error :

SQL> declare
cursor c1 is select "OBJ#", "COL#", "SEGCOL#", "SEGCOLLENGTH", "OFFSET",
2 3 "NAME", "TYPE#", "LENGTH", "FIXEDSTORAGE", "PRECISION#", "SCALE",
4 "NULL$", "DEFLENGTH", "DEFAULT$", "INTCOL#", "PROPERTY", "CHARSETID",
5 "CHARSETFORM", "SPARE1", "SPARE2", "SPARE3", "SPARE4", "SPARE5",
"SPARE6"
6 7 from col$ where default$ is not null;
8 type coltype is table of c1%rowtype;
9 colrec coltype;
begin
10 11 open c1;
loop
12 13 fetch c1 bulk collect into colrec limit 100000;
14 exit when colrec.count = 0;
15 forall i in 1 .. colrec.count
16 insert /*+ APPEND_VALUES */ into testcolmig ("OBJ#", "COL#", "SEGCOL#",
17 "SEGCOLLENGTH", "OFFSET",
18 "NAME", "TYPE#", "LENGTH", "FIXEDSTORAGE", "PRECISION#", "SCALE",
19 "NULL$", "DEFLENGTH", "DEFAULT$", "INTCOL#", "PROPERTY", "CHARSETID",
20 "CHARSETFORM", "SPARE1", "SPARE2", "SPARE3", "SPARE4", "SPARE5",
21 "SPARE6")
22 values(colrec(i)."OBJ#", colrec(i)."COL#", colrec(i)."SEGCOL#",
23 colrec(i)."SEGCOLLENGTH",
colrec(i)."OFFSET", colrec(i)."NAME", colrec(i)."TYPE#",
24 25 colrec(i)."LENGTH", colrec(i)."FIXEDSTORAGE", colrec(i)."PRECISION#",
26 colrec(i)."SCALE", colrec(i)."NULL$", colrec(i)."DEFLENGTH",
27 colrec(i)."DEFAULT$", colrec(i)."INTCOL#", colrec(i)."PROPERTY",
28 colrec(i)."CHARSETID", colrec(i)."CHARSETFORM", colrec(i)."SPARE1",
29 colrec(i)."SPARE2", colrec(i)."SPARE3", colrec(i)."SPARE4",
30 colrec(i)."SPARE5", colrec(i)."SPARE6");
31 commit;
32 end loop;
33 commit;
34 end;
35 /
declare
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind
ORA-06512: at line 13

 

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