How do I create a user defined function for Spring's SimpleJdbcCall?

63 views
Skip to first unread message

Igor Aptekar

unread,
May 19, 2022, 4:29:19 AM5/19/22
to H2 Database
Hi, I have a codebase that uses Spring's SimpleJdbcCall to execute stored procedures on an Oracle instance. Basically,

Map<String,Object> response = call.execute(input);

so later there is;

obj.setField(response.get("FIELD"));

However, when I create my H2 function and have it return a HashMap with the rows I need, it returns something else. I think it's a Map that wraps a resultset that has a list of value objects or something like that. Is there a way I can get my function to return a Map with just the field names and values?
Reply all
Reply to author
Forward
0 new messages