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

Oracle Community | User_OIM | 4 years ago
  1. 0

    Error while creating more than 100 users using Flatfile Recon

    Oracle Community | 4 years ago | User_OIM
    java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column
  2. 0

    Connector SAP Issue with a load balance

    Oracle Community | 6 years ago | 789060
    java.sql.SQLException: ORA-12899: value too large for column "OIM_ADMIN"."TSH"."ERROR" (actual: 441, maximum: 400)
  3. 0

    Error: Unable to insert new audit record for auditee 21 in repository UPA..

    Oracle Community | 7 years ago | 703604
    java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Oracle hibernate ORA-01461 CLOB

    Stack Overflow | 3 years ago | Eugen
    java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column
  6. 0

    Why does my Oracle PreparedStatement sometimes never return despite no contention?

    Stack Overflow | 3 years ago | user3262576
    java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column

  1. mellson 2 times, last 3 months ago
8 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLException

    ORA-01461: can bind a LONG value only for insert into a LONG column

    at oracle.jdbc.driver.SQLStateMapping.newSQLException()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.executeUpdate
    1. oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
    2. oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
    3. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
    4. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
    5. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
    6. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
    7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
    8. oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:947)
    9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
    10. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3381)
    11. oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3462)
    12. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1349)
    12 frames
  3. com.thortech.xl
    QuartzWrapper$TaskExecutionAction.run
    1. com.thortech.xl.scheduler.core.quartz.QuartzWrapper.updateStatusToError(Unknown Source)
    2. com.thortech.xl.scheduler.core.quartz.QuartzWrapper.access$600(Unknown Source)
    3. com.thortech.xl.scheduler.core.quartz.QuartzWrapper$TaskExecutionAction.run(Unknown Source)
    3 frames
  4. Thor.API.Security
    jbossLoginSession.runAs
    1. Thor.API.Security.LoginHandler.jbossLoginSession.runAs(Unknown Source)
    1 frame
  5. com.thortech.xl
    QuartzWrapper.execute
    1. com.thortech.xl.scheduler.core.quartz.QuartzWrapper.execute(Unknown Source)
    1 frame
  6. quartz
    SimpleThreadPool$WorkerThread.run
    1. org.quartz.core.JobRunShell.run(JobRunShell.java:203)
    2. org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
    2 frames