Dear Kettle fans,
PDI-200 has been out there for a while now. Jens created the feature request a little over 3 years ago. I guess the main thing blocking this issue was not as much a technical problem but more of a licensing and dependency one (Oracle JDBC dependency and distribution license).
However, now that we have the User Defined Java Class step we can work around those pesky problems. That is because the Java code in there only gets compiled and executed at runtime so it’s perfectly fine to create any sort of dependency in there you like.
The following transformation reads a set of rows from a stored procedure as described on this web page.
In short, our UDJC step executes the following code:
begin ? := sp_get_stocks(?);