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

**Anilrgowda** · 15-Oct-2007, 03:24 AM

Question: 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 ?

15-Oct-2007, 03:24 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 Question: 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 ? ------------------