java.sql.SQLException: ORA-01401: inserted value too large for column ORA-06512: at line 1at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:189)

Oracle Community | Ogroef-Oracle | 1 decade ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    WHEN IMPLEMENTING THE FILESENDERCUSTOMIZER CLASS AN ORA-01401 IS RECEIVED

    Oracle Community | 1 decade ago | Ogroef-Oracle
    java.sql.SQLException: ORA-01401: inserted value too large for column ORA-06512: at line 1at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:189)
  2. 0

    Err calling proc: ORA-00900: Invalid SQL Stmt | dBforums – Everything on Databases, Design, Developers and Administrators

    dbforums.com | 8 months ago
    java.sql.SQLException: ORA-00900: invalid SQL statement at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:134) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:2 89)
  3. 0

    On Thu, 2005-03-03 at 08:07 -0600, Dan Duensing wrote: In our nearing upgrade to uPortal2.4 we have greatly increased the number of bookmarks avaliable to the user. When testing this, I believe the length of BOOKMARK_XML is exceeding the max of the LONG datatype. We are getting the ORACLE SQL error below when it tries to INSERT to UPC_BOOKMARKS and no bookmarks are saved for the user in that table. Has anyone else encountered this and come up with a resolution? ERROR [uPortal thread pool worker #9] jasig.portal.[] Mar/02 17:11:28 - java.sql.SQLException: ORA-01704: string literal too long java.sql.SQLException: ORA-01704: string literal too long at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1451) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:862) at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1839) at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1764) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2354) at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:858) at org.jasig.portal.channels.CBookmarks.getDefaultBookmarks(CBookmarks.java:238) at org.jasig.portal.channels.CBookmarks.getBookmarkXML(CBookmarks.java:150) at org.jasig.portal.channels.CBookmarks.renderViewModeXML(CBookmarks.java:553) at org.jasig.portal.channels.CBookmarks.renderXML(CBookmarks.java:528) at org.jasig.portal.ChannelRenderer$Worker.run(ChannelRenderer.java:528) at org.jasig.portal.utils.threading.Worker.run(Worker.java:88) Has anyone else encountered this and come up with a resolution? Dan Duensing Internet Development KU Medical Center 913-588-7402

    Apereo Issues | 1 decade ago | Brad Johnson
    java.sql.SQLException: ORA-01704: string literal too long at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    ULTRASEARCH UNABLE TO FIND INSTANCE ERROR WKG-10602

    Oracle Community | 1 decade ago | 396942
    java.sql.SQLException: ORA-20000: Oracle Ultra Search errorWKG-10602: Instance does not exist ORA-06512: at "WKSYS.WK_ERR", line 179 ORA-06512: at line 1at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:185)
  6. 0

    On Thu, 2005-03-03 at 08:07 -0600, Dan Duensing wrote: In our nearing upgrade to uPortal2.4 we have greatly increased the number of bookmarks avaliable to the user. When testing this, I believe the length of BOOKMARK_XML is exceeding the max of the LONG datatype. We are getting the ORACLE SQL error below when it tries to INSERT to UPC_BOOKMARKS and no bookmarks are saved for the user in that table. Has anyone else encountered this and come up with a resolution? ERROR [uPortal thread pool worker #9] jasig.portal.[] Mar/02 17:11:28 - java.sql.SQLException: ORA-01704: string literal too long java.sql.SQLException: ORA-01704: string literal too long at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1451) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:862) at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1839) at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1764) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2354) at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:858) at org.jasig.portal.channels.CBookmarks.getDefaultBookmarks(CBookmarks.java:238) at org.jasig.portal.channels.CBookmarks.getBookmarkXML(CBookmarks.java:150) at org.jasig.portal.channels.CBookmarks.renderViewModeXML(CBookmarks.java:553) at org.jasig.portal.channels.CBookmarks.renderXML(CBookmarks.java:528) at org.jasig.portal.ChannelRenderer$Worker.run(ChannelRenderer.java:528) at org.jasig.portal.utils.threading.Worker.run(Worker.java:88) Has anyone else encountered this and come up with a resolution? Dan Duensing Internet Development KU Medical Center 913-588-7402

    Apereo Issues | 1 decade ago | Brad Johnson
    java.sql.SQLException: ORA-01704: string literal too long at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)

    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-01401: inserted value too large for column ORA-06512: at line 1at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:189)

      at oracle.jdbc.ttc7.TTIoer.processError()
    2. oracle.jdbc.ttc7
      Oall7.receive
      1. oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:242)
      2. oracle.jdbc.ttc7.Oall7.receive(Oall7.java:554)
      2 frames