Home » Infrastructure » Unix » ORA-06502 error on buffer size
ORA-06502 error on buffer size [message #98496] Wed, 01 December 2004 13:10 Go to next message
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 Go to previous message
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.
Previous Topic: Migration from Unix Oracle 7.i database to W2000 8.i
Next Topic: How to determine Oracle versions
Goto Forum:
  


Current Time: Fri Nov 22 15:12:36 CST 2024