point1234 opened a new issue, #4858: URL: https://github.com/apache/hop/issues/4858
### What would you like to happen? The 'Call DB Procedure' transformation, it's impossible to retrieve the return values where we're using JDBC drivers, as stated on the Help Page "The Call DB Procedure transform allows you to execute a database procedure (or function) and get the result(s) back. With MySQL and JDBC, it is not possible to retrieve the result set of a stored procedure. Stored procedures and functions can only return values through their function arguments and those arguments must be defined in the Parameters section of the DB Procedure Call configuration." I don't know why this happens, but it's the exactly same phrase and limitation that was present at PentaHo. There are some other open-source projects that use JDBC and are able to retrieve the values, so it's not an JDBC limitation. For example, DBeaver project. It's a very big limitation for some use cases, so please can you implement this? ### Issue Priority Priority: 3 ### Issue Component Component: Transforms -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
