ORA-06502 error on buffer size [message #98496] |
Wed, 01 December 2004 13:10 |
Neha
Messages: 20 Registered: July 2000
|
Junior Member |
|
|
I have a field in my name which is varchar2(1024) and it gives me the following error when I tried to load this value into the table:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
The data length in this field is 300 characters long.
Any suggestions?
|
|
|
Re: ORA-06502 error on buffer size [message #98497 is a reply to message #98496] |
Wed, 01 December 2004 18:31 |
Daljit Singh
Messages: 290 Registered: October 2003 Location: Texas
|
Senior Member |
|
|
Hi,
First of all check whether this error is occuring due to this varchar2(1024) column only or there is any other field in your insert statement which is causing error. Also check whether there are any constraint on your table or not and your insert statement is not violating that constraint definition like inserting NULL into NOT NULL column etc.
Daljit Singh.
|
|
|