We have a number of stored procedures in production that we would like to use with LC. I reviewed the JDBC types and I don't see any way to get LC to accept the results of a call to a stored procedure, the stored procedure service only has an output for the number of rows affected. In fact the only JDBC service I see that even handles results from a data base is the Multi Query XML one.
Is it possible to use stored procedures that return actual results in LC and if so how?
UPDATE: Preliminary investigation indicates that the best way to do this is to use the Web Service process to call out side of the process and return the results from that and use the process as a pass through.