org.springframework.dao.InvalidDataAccessApiUsageException: Unable to determine the correct call signature - no procedure/function/signature for 'PROCONEINPARAMETER'

Stack Overflow | deltaVee | 9 months ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    No procedure/function/signature

    Stack Overflow | 9 months ago | deltaVee
    org.springframework.dao.InvalidDataAccessApiUsageException: Unable to determine the correct call signature - no procedure/function/signature for 'PROCONEINPARAMETER'
  2. 0

    Spring - calling stored function with complex result

    Stack Overflow | 3 years ago | INeedMySpace
    org.springframework.dao.InvalidDataAccessApiUsageException: Required input parameter 'i_out' is missing

    Root Cause Analysis

    1. org.springframework.dao.InvalidDataAccessApiUsageException

      Unable to determine the correct call signature - no procedure/function/signature for 'PROCONEINPARAMETER'

      at org.springframework.jdbc.core.metadata.GenericCallMetaDataProvider.processProcedureColumns()
    2. Spring Framework
      SimpleJdbcCall.executeFunction
      1. org.springframework.jdbc.core.metadata.GenericCallMetaDataProvider.processProcedureColumns(GenericCallMetaDataProvider.java:347)
      2. org.springframework.jdbc.core.metadata.GenericCallMetaDataProvider.initializeWithProcedureColumnMetaData(GenericCallMetaDataProvider.java:112)
      3. org.springframework.jdbc.core.metadata.CallMetaDataProviderFactory$1.processMetaData(CallMetaDataProviderFactory.java:133)
      4. org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:299)
      5. org.springframework.jdbc.core.metadata.CallMetaDataProviderFactory.createMetaDataProvider(CallMetaDataProviderFactory.java:73)
      6. org.springframework.jdbc.core.metadata.CallMetaDataContext.initializeMetaData(CallMetaDataContext.java:286)
      7. org.springframework.jdbc.core.simple.AbstractJdbcCall.compileInternal(AbstractJdbcCall.java:303)
      8. org.springframework.jdbc.core.simple.AbstractJdbcCall.compile(AbstractJdbcCall.java:288)
      9. org.springframework.jdbc.core.simple.AbstractJdbcCall.checkCompiled(AbstractJdbcCall.java:348)
      10. org.springframework.jdbc.core.simple.AbstractJdbcCall.doExecute(AbstractJdbcCall.java:375)
      11. org.springframework.jdbc.core.simple.SimpleJdbcCall.executeFunction(SimpleJdbcCall.java:153)
      11 frames
    3. test.jdbc
      SimpleJdbcTest.main
      1. test.jdbc.StringDao.executeProcOneINParameter(StringDao.java:21)
      2. test.jdbc.SimpleJdbcTest.main(SimpleJdbcTest.java:15)
      2 frames