ora-01461 can bind a long value only for insert into a long column
448778Dec 13 2008 — edited Dec 14 2008Guys,
In my production DB 10.2.0.3 with NLS_CHARACTERSET WE8ISO8859P1 using Oracle JDBC Driver version - "10.2.0.1.0", The application is showing
"ora-01461 can bind a long value only for insert into a long column" and thereis no log written by Oracle in the alert log or any user dump file.
I am not able to find out why I am getting this error,and on which table the insert statement is failing.Only 10% of inserts are failing.
I search on the metalink and google (http://vsadilovskiy.wordpress.com/2007/10/19/ora-01461-can-bind-a-long-value-only-for-insert-into-a-long-column/).
There is no CLOB column in the database and maximum data_lenght for any varchar column is 2000.
In the link above it suggest setting 1461 event on the database so that SMON can log the error in the log file.Is there any implications in doing that in the busy oltp environment.
I can't enable DML error logging feature of 10g to write DML errors in the custome table as it needs code change in the application.
What are the other options for me to track this error?