admin管理员组

文章数量:1122846

I am not able to call a stored procedure from Spring Boot 3.3, but I am able to establish a database connection use fetch queries.

When calling the stored procedure, I am getting this error:

Error calling CallableStatement.getMoreResults 
[ERROR: procedure def.abc(character varying, character varying) does not exist
Hint: No procedure matches the given name and argument types. You might need to add explicit type
casts. Position: 6] 
[HikariProxyCallableStatement@2039624079 wrapping call def.abc(('10107'),('10107'))];
SQL [HikariProxyCallableStatement@2039624079 wrapping call def.abc(('10107'),('10107'))]

I have created the stored procedure in postgresDB like this: def.abc(code character varying, pincode character varying)

本文标签：

版权声明：本文标题：Postgresql Procedure not getting called from spring boot 3.3 but database connection has established successfully - Stack Overfl 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1736303661a1931962.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。