Errors during Insert operation in Pro*C [message #397776] |
Mon, 13 April 2009 20:16 |
oracle123
Messages: 56 Registered: March 2009
|
Member |
|
|
Hi All,
I am receiving the following error while inserting records.
"Oracle Error:ORA-12899: value too large for column "MFG_ADMIN"."GAGE_RESULTS"."COMP
whereas I am checking the length of all values before inserting and am sure that none of them are larger than column lengths.
I did some research and found this error might be due to character set.
select * from nls_database_parameters where parameter like '%CHARACTERSET';
PARAMETER VALUE
------------------------------
----------------------------------------------------------------------------------------------------
--------------------
NLS_CHARACTERSET UTF8
NLS_NCHAR_CHARACTERSET UTF8
Please let me know how can this be related to my problem or if something else is causing this error.
Thanks,
Scott.
|
|
|
|
Re: Errors during Insert operation in Pro*C [message #398017 is a reply to message #397776] |
Tue, 14 April 2009 19:36 |
oracle123
Messages: 56 Registered: March 2009
|
Member |
|
|
Michel,
I once again did the same mistake. Declared the variable as char datatype and passing it in the insert statement. The value I was passing is less than the database column length but not the array holding it.
I declared it as VARCHAR datatype and it is now working fine.
Thanks,
Soctt.
|
|
|
|