According to documentation <https://docs.oracle.com/en/database/oracle/oracle-database/12.2/jjdbc/JDBC-reference-information.html#GUID-E77C2AE8-E22B-48BF-A4CB-010CBC8FE7C2> Oracle creates a temporary SQL type with the same name of PLSQL Type:
All PL/SQL package types are mapped to a system-wide unique name that can > be used by JDBC to retrieve the server-side type metadata. The name is in > the following form: > [SCHEMA.]<PACKAGE>.<TYPE> I didn't find it but I read a good example how it works in Oracle 12: Oracle creates a new Object Type to workaround this! On Thursday, May 24, 2018 at 9:33:29 AM UTC-3, Lukas Eder wrote: > > > > 2018-05-24 2:31 GMT+02:00 Rafael Ponte <[email protected] <javascript:>>: > >> Interesting to know Oracle is investing some effort in improving JDBC >> driver to make developer's life easier. Not supporting boolean and other >> types is very annoying and bothers me too much. >> > > Boolean types, I believe, are supported with ojdbc 12.1. But of course, > why worry about that when jOOQ can emulate them for you as well :-) > > >> As far as I know Oracle 12c doesn't serialize Record Types but converts >> them to temporary Object types. If I'm not wrong I think I read this in the >> own 12c documentation. Or are you talking about another thing? >> > > I don't know how they managed to pull it off. I wouldn't be surprised if > they went through as many hoops as jOOQ does :-) > > -- 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.
