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

Oracle Community | 68768 | 1 decade ago
  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

    Stack Overflow | 4 years ago | user1344022
    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

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

    dolinked.com | 1 year 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
  6. 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]

    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-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