Hi Craig,
So, what I would do is :
1- create first a VIEW, to get the data out of the tables.
2- create a function that opens a CURSOR, based on the VIEW created in
the step 1, and returns it
3- In my Java code, via a CallableStatement, get returned data as a
ResultSet
That way you have some gains in time used parsing the query.
Regards,
Andrés