Thank you very much for following up and for debugging this. I knew I should have tested this with version 3.9.1 - I ran my tests with 3.10.0-SNAPSHOT, which do not have the problem anymore. Unfortunately, the issue was fixed without a separate ticket in https://github.com/jOOQ/jOOQ/issues/5850.
I've now created a new issue for this problem: https://github.com/jOOQ/jOOQ/issues/6055 The fix will be merged in 3.9.2 (to be released this week, hopefully), and 3.8.8. I'm afraid, I currently don't see any workaround apart from using procedures rather than functions, for the time being. Thanks again for reporting! Lukas 2017-04-11 15:15 GMT+02:00 Marcus Müller <[email protected]>: > Hi Lukas, > > It is the binding of the return parameter. A stored procedure with a > BOOLEAN paramer but no return parameters like > > > CREATE OR REPLACE PROCEDURE TestProcedure3(a IN NUMBER, Flag IN BOOLEAN, b > IN VARCHAR2) IS > BEGIN > IF(Flag=TRUE) THEN > debug(a); > ELSE > debug(b); > END IF; > END; > / > > > works properly with jOOQ.So the issue is not with BOOLEAN parameters > themself but with the binding of return/out parameters of > functions/procedures. > > Marcus > > > > -- > You received this message because you are subscribed to the Google Groups > "jOOQ User Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
