My Oracle Support Banner

After Upgrading Database And JDBC From 10.2.0.2 To 10.2.0.3 Intermittent ORA-01461 Errors Occur (Doc ID 461670.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 and later
JDBC - Version 10.2.0.3 and later
Information in this document applies to any platform.
***Checked for relevance on 04-Feb-2013***

Symptoms

A large application accesses the database through JDBC connections. A few days after upgrading the database and JDBC jar files from 10.2.0.2 to 10.2.0.3, random ORA-01461 errors started to occur. The errors are not tied to any table or statement.

The exception reported by JDBC is:

    java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column

The ORA-01461 occurs on statements like:
    UPDATE table SET column = ? <... where clause ...>
and
    INSERT INTO table VALUES (?, ?)

The ORA-01461 did not occur with the 10.2.0.2 database.

Changes

Upgraded the database from 10.2.0.2 to 10.2.0.3.

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!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.