java.sql.SQLException: ORA-22814: attribute or element value is larger than specified in type

Oracle Community | 320647 | 1 decade ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    LPX-00004 - Problems while inserting xml files in a xmltype column

    Oracle Community | 1 decade ago | 320647
    java.sql.SQLException: ORA-22814: attribute or element value is larger than specified in type
  2. 0

    java.sql.SQLException: ORA-06550: after calling procedure from java code

    dolinked.com | 2 years ago
    java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00201: identifier 'SCHEMA_RESTORE.RESTORE' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored
  3. 0

    PLS-00201: Not able to execute Oracle Package through Java app

    Oracle Community | 5 years ago | 898327
    java.sql.SQLException: ORA-06550: line 1, column 7:+ PLS-00201: identifier 'uhbvn_public.GENSYSLOGIN' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored +06:36:17,500 ERROR [STDERR]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    JDBC Connections not being returned to pool

    Oracle Community | 1 decade ago | 666705
    java.sql.SQLException: ORA-01401: inserted value too large for column
  6. 0

    Error using setTimestamp and ojdbc14 against Oracle 7.3.4

    Oracle Community | 1 decade ago | 358181
    java.sql.SQLException: ORA-03115: unsupported network datatype or representation

  1. rp 1 times, last 4 months ago
26 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-22814: attribute or element value is larger than specified in type

    at oracle.jdbc.dbaccess.DBError.throwSqlException()
  2. oracle.jdbc.dbaccess
    DBError.throwSqlException
    1. oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
    1 frame
  3. oracle.jdbc.ttc7
    TTC7Protocol.parseExecuteFetch
    1. oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
    2. oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
    3. oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
    4. oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093)
    4 frames
  4. Oracle jdbc
    OraclePreparedStatement.execute
    1. oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2047)
    2. oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)
    3. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2709)
    4. oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589)
    5. oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:656)
    5 frames
  5. Unknown
    test.main
    1. test.insertXML(test.java:84)
    2. test.main(test.java:261)
    2 frames