I have a stored procedure that returns a cursor and the cursor contains another cursor (col_ch in the bellow example). It is something like this (as I’m seeing it in my Java code) PROCEDURE my_proc ( i_val IN VARCHAR ,i_cont IN INTEGER ,o_out OUT CURSOR ); On my Java app I’m seeing in debug values from o_out id t_id col_ch
Tag: stored-procedures
procedure myProcedure (text, text) does not exist Hint: No procedure matches the given name and argument types
whenever trying calling any stored procedure in PostgreSQL 11.4 from my java application but getting this issue procedure pkg$my_procedure(text, text) does not exist. Note that I’m able to call the SP from DB. im using PostgreSQL JDBC version 42.2.16 the SP declaration Java code to call the SP the Exception the call from PostgreSQL Answer You created the stored procedure
How to call a PostgreSQL stored procedure with Hibernate
I want to create a Stored Procedure in PostgreSQL to make some calculation and return it to My java call. I have tried Most of the option from Java-Hibernate but not able to succeed. Below is my SP. In Java How to call this procedure to get the values. NOTE: I’m not using hibernate XML files to call quires. Please
Stored Procedure returning multiple tables to spring jdbc template
Iam calling a stored procedure from my Spring DAO class using JdbcTemplate. My problem is that, stored procedure returns multiple tables. Is there a way to access multiple tables using Spring JdbcTemplate. If I use jdbcTemplate.queryForList(myStoredProc, new Object[]{parameters} iam getting only first table from the result. My database is SQL Server 2005. Is there any method other than jdbcTemplate for