You can try using plain SQL methods, such as Factory.execute(): http://www.jooq.org/javadoc/latest/org/jooq/impl/Factory.html#execute(java.lang.String)
This might work if your JDBC driver supports calling stored procedures through PreparedStatements (as opposed to CallableStatements) If your JDBC driver doesn't support that, I'm afraid this is not yet possible. A pending feature request for plain SQL stored procedure calls is on the roadmap, though: https://github.com/jOOQ/jOOQ/issues/1640 Cheers Lukas 2012/11/2 Marko Frelih <[email protected]>: > Yes, ok, but how do we do it without code generator? > > Sincerely, > Marko > > > On Fri, Nov 2, 2012 at 3:29 PM, Lukas Eder <[email protected]> wrote: >> >> Hello, >> >> > Is there a way to call existing stored procedure from local database >> > using >> > jooq? >> >> Yes, jOOQ's stored procedure support is documented in the manual: >> http://www.jooq.org/doc/2.6/manual/sql-execution/stored-procedures/ >> >> Cheers >> Lukas > >
