> this is a good workaround: the most important thing is the correct
> deserialization of the arrays.

I have some integration tests regarding TABLE OF OBJECT and VARRAY OF
OBJECT types:
https://github.com/jOOQ/jOOQ/blob/master/jOOQ-test/src/org/jooq/test/jOOQOracleTest.java#L937

I hope this works fine for you, too.

> i'll try it! :)

Any further feedback welcome. Note, I'm not getting a lot of feedback
about these features. Specifically, I would be interested in
suggestions for improvements for the org.jooq.ArrayRecord type.
Personally, I'm not so happy with it. I feel it is a bit clumsy to
use.

May I ask what is your motivation for operating on MULTISETS, TABLE
TYPES, etc? Have you considered using jOOQ 2.5.0's new fetchGroups
methods as documented here:
http://www.jooq.org/doc/2.5/manual/sql-execution/fetching/arrays-maps-and-lists/

I'm guessing that the real query is a lot more complex than your example...?

Cheers
Lukas

Reply via email to