JOOQ doesn't set a parameter when its marked as both IN and OUT

6 views
Skip to first unread message

Trisha gangadhar

unread,
Mar 22, 2022, 3:01:50 PMMar 22
to jOOQ User Group
I am using a setter to set an IN Parameter, in my oracle stored procedure, its marked as below

PROCEDURE test
    (
       test_1                        IN OUT       someType,
      test_2                         IN.               someType
)

when I use the setter , setTest1 which is auto generated 
Test test = new Test();
test.setTest1("something")
, it sets the value. But when I execute
test.execute(configuration). the binding log shows the value as ? and I get this error
"wrong number or types of arguments in call" , I see all other params are set successfully.

Is this is a known issue? what is the workaround?


Lukas Eder

unread,
Mar 22, 2022, 3:05:10 PMMar 22
to jOOQ User Group
Hi Trisha,

Thanks for your message. I'm not aware of such a limitation, at least not for those dialects for which we support stored procedures. Can you provide a more complete reproducer, including:

- What RDBMS is this about
- What version of jOOQ are you using
- What specific type is someType
- How did you set up your code generator
- Anything else the helps reproduce the issue

Note we have a template to create MCVE's for bug reports and support requests: https://github.com/jOOQ/jOOQ-mcve. Perhaps that's helpful

Thanks,
Lukas

--
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 jooq-user+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/268f12ca-9687-4e72-b072-3a77cfc6b50an%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages