Hi Manfred, The reported ORA-01427 is caused by a bad query against the Oracle dictionary views. The subquery CONSTRAINT_NAME = (select...) seems to be invalid in some special foreign key configurations. Unfortunately, I could not reproduce this with the partial schema you provided, but the overall query is much too complex for the data it needs to fetch. I could rephrase the query to produce an equivalent result, and the ORA-01427 shouldn't be possible anymore.
This is fixed on trunk with https://sourceforge.net/apps/trac/jooq/ticket/569 And I released a 1.6.0-SNAPSHOT version: https://oss.sonatype.org/content/repositories/snapshots/org/jooq/ Or you wait until next week for the 1.6.0 release. Cheers Lukas
