I don't know much about DB2, but this procedure from our unit tests
works:
http://svn.apache.org/repos/asf/cayenne/main/trunk/framework/cayenne-jdk1.5-unpublished/src/test/resources/ddl/db2/create-select-sp.sql
Maybe that will give you some ideas.
Andrus
On Jun 15, 2010, at 8:35 AM, Juergen Saar wrote:
I have the same problem with Informix ... still using a
SQLTemplate ...
2010/6/14 Kuhns, John <[email protected]>
I am attempting to call a DB2 stored proc that returns a result
set, so far
no luck. The procedure takes two input params, and the docs imply
I'm doing
this correctly, but I must be missing something.
For now I am using a SQLTemplate query and building the call
statement on
the fly. I'd like to know the "correct" way to do it, however,
since I am
integrating with a legacy system with a lot of oddities in date/
time formats
and normalization that I'd like to use stored procs to get around.
