org.springframework.jdbc.BadSqlGrammarException: CallableStatementCallback; bad SQL grammar [{? = call TEST_FUNCTION(?, ?)}]; nested exception is java.sql.SQLException: ORA-06550: line 1, column 13: PLS-00905: object TEST.TEST_FUNCTION is invalid ORA-06550: line 1, column 7: PL/SQL: Statement ignored

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

Solutions on the web

via Spring JIRA by Costa Basil, 1 year ago
CallableStatementCallback; bad SQL grammar [{? = call TEST_FUNCTION(?, ?)}]; nested exception is java.sql.SQLException: ORA-06550: line 1, column 13: PLS-00905: object TEST.TEST_FUNCTION is invalid ORA-06550: line 1, column 7: PL/SQL: Statement ignored
via Spring JIRA by Costa Basil, 1 year ago
CallableStatementCallback; bad SQL grammar [{? = call TEST_FUNCTION(?, ?)}]; nested exception is java.sql.SQLException: ORA-06550: line 1, column 13: PLS-00905: object TEST.TEST_FUNCTION is invalid ORA-06550: line 1, column 7: PL/SQL: Statement ignored
via Coderanch by Anadi Misra, 10 months ago
CallableStatementCallback; bad SQL grammar [{call GET_EVENT_BY_TITLE(?, ?, ?, ?, ?, ?)}]; nested exception is java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at "APPUSER.GET_EVENT_BY_TITLE", line 10 ORA-06512: at line 1
via stackexchange.com by Unknown author, 2 years ago
StatementCallback; bad SQL grammar []; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open backup device 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\media\baks\mydbbak.bak'. Operating system error 3(failed to retrieve text for this error. Reason: 15105).
via Database Administrators by u123
, 1 year ago
StatementCallback; bad SQL grammar []; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open backup device 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\media\baks\mydbbak.bak'. Operating system error 3(failed to retrieve text for this error. Reason: 15105).
via scriptscoop.com by Unknown author, 2 years ago
StatementCallback; bad SQL grammar [select * from book]; nested exception is org.postgresql.util.PSQLException: The column name borrowedby was not found in this ResultSet.
org.springframework.jdbc.BadSqlGrammarException: CallableStatementCallback; bad SQL grammar [{? = call TEST_FUNCTION(?, ?)}]; nested exception is java.sql.SQLException: ORA-06550: line 1, column 13: PLS-00905: object TEST.TEST_FUNCTION is invalid ORA-06550: line 1, column 7: PL/SQL: Statement ignored
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:626)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:184)
at oracle.jdbc.driver.T4CCallableStatement.execute_for_rows(T4CCallableStatement.java:873)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1090)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2905)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:2996)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4120)
at org.springframework.jdbc.core.JdbcTemplate$5.doInCallableStatement(JdbcTemplate.java:984)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:933)
at org.springframework.jdbc.core.JdbcTemplate.call(JdbcTemplate.java:982)
at org.springframework.jdbc.core.simple.AbstractJdbcCall.executeCallInternal(AbstractJdbcCall.java:362)
at org.springframework.jdbc.core.simple.AbstractJdbcCall.doExecute(AbstractJdbcCall.java:336)
at org.bchousing.common.jdbc.spring.DefaultPlSqlProcedureMetaDataProvider.main(DefaultPlSqlProcedureMetaDataProvider.java:194)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 6 months 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
76 more bugmates

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