Getting ORA-01461 With 9i Oracle Database
(Doc ID 824636.1)
Last updated on FEBRUARY 06, 2024
Applies to:
JDBC - Version 10.2.0.1 to 11.1.0.7 [Release 10.2 to 11.1]Information in this document applies to any platform.
This problem can occur on any platform.
Symptoms
With Database version 9.2.0.7 following error thrown while inserting characters to a table consist of two varchar2 columns, It occurs with 11g and 10g JDBC drivers, but no issue observed with 9.2.0.8 JDBC driver.
Error : java.sql.SQLException: ORA-01461 : can bind a LONG value only for insert
into a LONG column
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |