I have defined a Collections type in Oracle

create or replace TYPE Collections AS TABLE OF varchar2(64);

This type is used in one of the tables. I would like to have Hibernate mapped this "Collections" Oracle type.

If you have done this before, please give me some guidances or an example.


Thanks

I have not done exactly this before, but I think the best approach would be to implement a User Type. I've done that, for instance, for YAML packed into a string and an array of base64-encoded integers packed into a string.

See section 5.2.3 of the manual and the javadoc for UserType or CompositeUserType.