org.springframework.jdbc.BadSqlGrammarException

CallableStatementCallback; bad SQL grammar [{call RGUERRA.PKG_SERVICIO_LLAMADAS.SP_OBTENER_SERV_LLAM_TYPE(?, ?, ?, ?)}]; nested exception is java.sql.SQLSyntaxErrorException: *ORA-00902: tipo de dato no válido*

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web292

  • via Google Groups by cesar ricardo guerra arnaiz, 6 months ago
    CallableStatementCallback; bad SQL grammar [{call RGUERRA.PKG_SERVICIO_LLAMADAS.SP_OBTENER_SERV_LLAM_TYPE(?, ?, ?, ?)}]; nested exception is java.sql.SQLSyntaxErrorException: ORA-00902: tipo de dato no válido
  • via Stack Overflow by Frank
    , 6 months ago
    CallableStatementCallback; bad SQL grammar [{call getrecord()}]; nested exception is com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: FUNCTION getrecord does not exist
  • via Stack Overflow by Jaikrat
    , 1 year ago
    CallableStatementCallback; bad SQL grammar [{? = call myFuncName()}]; nested exception is java.sql.SQLException: Parameter #1 has not been set.
  • Stack trace

    • org.springframework.jdbc.BadSqlGrammarException: CallableStatementCallback; bad SQL grammar [{call RGUERRA.PKG_SERVICIO_LLAMADAS.SP_OBTENER_SERV_LLAM_TYPE(?, ?, ?, ?)}]; nested exception is java.sql.SQLSyntaxErrorException: *ORA-00902: tipo de dato no válido* at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:94) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:969) at org.springframework.jdbc.core.JdbcTemplate.call(JdbcTemplate.java:1003) at org.springframework.jdbc.core.simple.AbstractJdbcCall.executeCallInternal(AbstractJdbcCall.java:391) at org.springframework.jdbc.core.simple.AbstractJdbcCall.doExecute(AbstractJdbcCall.java:376) at org.springframework.jdbc.core.simple.SimpleJdbcCall.execute(SimpleJdbcCall.java:177) at pe.com.javaman.dummy.servicioLlamadasWS.dao.ServicioLlamadasDaoImp.obtenerServicioLlamadasType(ServicioLlamadasDaoImp.java:366)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago