My Oracle Support Banner

Migration of OAM 10g to 11gR2 Fails with Error "java.sql.BatchUpdateException: ORA-01461" (Doc ID 1984063.1)

Last updated on APRIL 30, 2015

Applies to:

Oracle Access Manager - Version and later
Information in this document applies to any platform.


We attempted to migrate our OAM10g ( BP03 policies/webates etc to OAM11g ( BP02 but it fails with the following error in Admin Server log;

Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services -
2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.BatchUpdateException: ORA-01461: can bind a LONG
value only for insert into a LONG column

Error Code: 1461
@ InsertObjectQuery(
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseExce
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeJDK12B
at chStatement(

What might be the root cause of this?


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

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