Error - View Single Post - ORA-06502: PL/SQL: numeric or value error: character string buffer too small when usi

**Anilrgowda** · 20-Nov-2007, 12:14 AM

I was to trying to use the solution provided by mszacik for convert long raw into varchar2 data type in oracle 8i. I am using it in Oracle 9i.
Mostly it works fine. In some cases I got the error in SQLPlus as:
ERROR at line 2:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "ABC.TEXTRAWIO", line 62
The line 62:
62 hex_data := rawtohex(raw_data);
63 rawlen := length(hex_data);

I think this may related to the varchar2 data limit? if so , how can I deal with it ?

Thank you for advice

20-Nov-2007, 12:14 AM	#1 (permalink)
Anilrgowda Administrator Posts: 18,715 Join Date: Jan 2006 Rep Power: 10 IM:	ORA-06502: PL/SQL: numeric or value error: character string buffer too small when usi I was to trying to use the solution provided by mszacik for convert long raw into varchar2 data type in oracle 8i. I am using it in Oracle 9i. Mostly it works fine. In some cases I got the error in SQLPlus as: ERROR at line 2: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "ABC.TEXTRAWIO", line 62 The line 62: 62 hex_data := rawtohex(raw_data); 63 rawlen := length(hex_data); I think this may related to the varchar2 data limit? if so , how can I deal with it ? Thank you for advice ------------------