> From the combination you're using, I'd expect you be better off using > SQL Server generated artefacts against your Oracle database, avoiding > packages, UDT's, ARRAY types, REF CURSORs (which are not yet supported > in jOOQ's SQL Server integration).
Yes, this is what I had in mind. > > On a related topic, if a field is Boolean (BIT) on SQLServer but a > > Byte (TINYINT) on Oracle (with values 0=false, 1=true), [...] > > You probably mean NUMBER(1) on Oracle? Indeed. I was just referring to the SQLDataType the field is declared with by jOOQ. Thanks a lot for the explanations! -Christopher
