I just checked, Oracle 10g downloads are no longer available to customers with no commercial Oracle product licenses (e.g. me): http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
I'm afraid that I won't be able to easily integration-test jOOQ with Oracle 10g any further right now. Fixing this query may still be possible, but it's a bit of a "blind flight". I'm hoping to improve this situation in the near future. Cheers Lukas 2013/7/2 Lukas Eder <[email protected]> > > > > 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.
