possible to generate Routines for oracle supplied packages?

3 views
Skip to first unread message

olive...@gmail.com

unread,
May 31, 2017, 2:59:14 AM5/31/17
to jOOQ User Group
Hi,

(how) would it be possible to configure the jooq code generator to create Routines for
procedures/functions in oracle supplied packages such as DBMS_FLASHBACK?

Regards,
Oliver

Lukas Eder

unread,
May 31, 2017, 4:38:26 AM5/31/17
to jooq...@googlegroups.com
Hi Oliver,

Thank you very much for your message.

In principle, you'll simply need to specify the SYS schema as an inputSchema (and possibly use include / exclude to avoid generating the entire schema, there's a lot of content!)

From what I can tell, this package has a dependency on the types XID_ARRAY (which might not work in jOOQ as we don't support the RAW type yet) and TXNAME_ARRAY (which should work)

I hope this helps,
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 jooq-user+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply all
Reply to author
Forward
0 new messages