This page contains an archived post to the Java Answers Forum made prior to February 25, 2002. If you wish to participate in discussions, please visit the new Artima Forums.

Message:

ORA-01461

Posted by chandra on December 04, 2000 at 7:00 PM

Hi,

I am using a Prepared statement to update a table in a Session Bean(WebLogic server)
When I am trying to insert a date using setDate(int,java.sql.Date) I am getting following error error.I tried '?' also for for the placeholder.

java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a L
ONG column
at weblogic.db.oci.OciCursor.getCDAException(OciCursor.java:228)
at weblogic.jdbcbase.oci.Statement.executeUpdate(Statement.java:869)
at weblogic.jdbc20.pool.PreparedStatement.executeUpdate(PreparedStatemen
t.java:47)
at weblogic.jdbc20.rmi.internal.PreparedStatementImpl.executeUpdate(Prep
aredStatementImpl.java:54)
at weblogic.jdbc20.rmi.SerialPreparedStatement.executeUpdate(SerialPrepa
redStatement.java:55)
at com.oracle.itracker.ejb.message.ManageMessageBean.setMessageObject(Ma
nageMessageBean.java:615)

Thanks in advance,

Chandr

• ORA-01461 Peter May 31, 2001 at 10:52 AM (1)
  • java.sql.SQLException: ORA-01461 Ashutosh November 20, 2001 at 4:09 AM (0)