Hi,
I'm using Oracle 11g XE and I have this specific package:
create or replace PACKAGE My_Pkg IS
-- just my specific type
TYPE Varchar2_List IS TABLE OF Varchar2(4000);
-- trying to use my type and Dbms_Sql.Varchar2_Table
procedure does_something(p_ora_list Dbms_Sql.Varchar2_Table, p_my_list
Varchar2_List);
END My_Pkg ;
Notice my package has 2 associative array types: one for Oracle
Dbms_Sql.Varchar2_table and the other one for my custom type
(Varchar2_List).
So when I try to generate code via jOOQ generator (v3.10.6) I'm getting
this class:
public class MyPkg extends PackageImpl {
/**
* @deprecated Unknown data type. Please define an explicit {@link
org.jooq.Binding} to specify how this type should be handled.
* Deprecation can be turned off using <deprecationOnUnknownTypes/> in
your code generator configuration.
*/
@java.lang.Deprecated
public static void does_something(Configuration configuration, Object
pOraList, Object pMyList) {
// ...
}
}
It seems like jOOQ doesn't know both types, so it's considering them as
Unknown data types. As far as I know jOOQ supports associative arrays for
default SQL types (Number, Varchar2 etc) and custom SQL types (create type
"Product" as Object (...)).
Am I doing something wrong?
Thanks,
--
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.
