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

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

via Oracle Community by 68768, 1 year ago
ORA-01747: invalid user.table.column, table.column, or column specification
via Oracle Community by 68768, 1 year ago
ORA-01747: invalid user.table.column, table.column, or column specification
via Oracle Community by 843853, 1 year ago
ORA-06550: line 1, column 7: PLS-00221: 'PA_SEARCH_NOTES' is not a procedure or is undefined ORA-06550: line 1, column 7: PL/SQL: Statement ignored
via Stack Overflow by user1344022
, 10 months ago
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
via dolinked.com by Unknown author, 2 years ago
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
via Oracle Community by 843854, 11 months ago
ORA-29532: Java call terminated by uncaught Java exception: java.sql.SQLException: invalid arguments in call ORA-06512: at "SCOTT.TIC_GETGREETING", line 0 ORA-06512: at line 1
java.sql.SQLException: ORA-01747: invalid user.table.column, table.column, or column specification
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2047)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2709)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:656)
at storedproctest.StoredProcApp.(StoredProcApp.java:111)
at storedproctest.DBApp.(DBApp.java:20)
at storedproctest.DBApp.main(DBApp.java:49)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
2 times, 1 year ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.