Hello Landon, I see that this question has not been addressed so far.
2014-04-22 22:49 GMT+02:00 Landon Sykora <[email protected]>: > I'm attempting to call a routine inside a package in my database (dialect > = Oracle). The routine returns a Type defined in my database, namely > diag_table_type, which is a table of instances of diag_scalar_type. When > handling the return type, jOOQ sees it as an instance of > java.sql.Types.OTHER (integer 1111), and throws a DataAccessException with > the information "invalid column type 1111." I've read about the Converter > ability of jOOQ but I'm not sure if I could apply it here since all of this > happens at a jOOQ - generated code-level. I've attached a number of code > fragments. > What version of jOOQ are you using for this? There had been a couple of improvements related to Oracle OBJECT and TABLE types, recently. Have you tried turning on debug logging while running the jOOQ code generator? What output do you get? Some information about logging with jOOQ can be found here: http://www.jooq.org/doc/latest/manual/sql-execution/logging/ > Please be patient with any mistakes I've made or places I've been vague - > I'm a jOOQ novice and have never posted to this forum before =) > We're always patient :-) Cheers 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
