So Cayenne calls the sp in the following format:
> {? = call spXXX(?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}
In your JDBC test you do it like this:
> { call spXXX(?, ?, ?, ?, ?, ?, ?, ?, ?, ?) }
I.e. no return value is specified. So what if you uncheck "returning
value" checkbox for this stored procedure? Would you still get the
same error? (Sorry if my questions sound a bit random, I personally
haven't used stored procedures with Cayenne or JDBC for a couple of
years already, so my memory of all the quirks is a bit blurry).
If this doesn't work, could you send me a stored procedure definition
so that I could test that locally. If you don't want to send it to the
public mailing list, you can email it to me directly.
Andrus
This archive was generated by hypermail 2.0.0 : Thu Apr 17 2008 - 08:52:44 EDT