java.sql.SQLException: ORA-01747: invalid user.table.column, table.column, or column specification

Oracle Community | 68768 | 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

    SQLException Calling Stored Procedure

    Oracle Community | 1 decade ago | 68768
    java.sql.SQLException: ORA-01747: invalid user.table.column, table.column, or column specification
  2. 0

    SQLException Calling Stored Procedure

    Oracle Community | 1 decade ago | 68768
    java.sql.SQLException: ORA-01747: invalid user.table.column, table.column, or column specification
  3. 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
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

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

    Oracle Community | 6 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]
  6. 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

  1. rp 1 times, last 5 months ago
27 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-01747: invalid user.table.column, table.column, or column specification

    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. storedproctest
    DBApp.main
    1. storedproctest.StoredProcApp.<init>(StoredProcApp.java:111)
    2. storedproctest.DBApp.<init>(DBApp.java:20)
    3. storedproctest.DBApp.main(DBApp.java:49)
    3 frames