2013/7/2 Venkat Sadasivam <[email protected]> > Do you support Oracle 10g?
Yes, 10g should be supported by jOOQ, although I currently do not have the infrastructure set up to integration test both 10g and 11g with jOOQ. > I am getting below error when trying to generate the code. > Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: > "SYS"."ALL_PROCEDURES"."OBJECT_TYPE": invalid identifier > Thanks for reporting. It seems that this column was introduced in 10gR2: https://forums.oracle.com/thread/529899 It wasn't available in 10gR1 yet. I have registered #2584 for this. https://github.com/jOOQ/jOOQ/issues/2584 The offending query is in org.jooq.util.oracle.OracleDatabase.getRoutines0(): for (Record record : create().select( ALL_OBJECTS.OWNER, ALL_OBJECTS.OBJECT_NAME, ALL_OBJECTS.OBJECT_ID, ALL_PROCEDURES.AGGREGATE) .from(ALL_OBJECTS) .leftOuterJoin(ALL_PROCEDURES) .on(ALL_OBJECTS.OWNER.equal(ALL_PROCEDURES.OWNER)) .and(ALL_OBJECTS.OBJECT_TYPE.equal(ALL_PROCEDURES.OBJECT_TYPE)) .and(ALL_OBJECTS.OBJECT_NAME.equal(ALL_PROCEDURES.OBJECT_NAME)) .where(ALL_OBJECTS.OWNER.upper().in(getInputSchemata()) .and(ALL_OBJECTS.OBJECT_TYPE.in("FUNCTION", "PROCEDURE"))) .orderBy( ALL_OBJECTS.OWNER, ALL_OBJECTS.OBJECT_NAME, ALL_OBJECTS.OBJECT_ID) .fetch()) { ... I'm sure there's a way to express the same query without using ALL_PROCEDURES.OBJECT_TYPE 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/groups/opt_out.
