JOOQ supportability for the stored procs which returns SET OF RECORD

[suman choudhary]

Hi Lukas,

My stored procedure is returning a SET OF TEXT, but when Jooq reads from the physical schema, it treats the stored procedure as a BASE TABLE instead of a ROUTINE. Do you have any insights on why this might be occurring?

Thanks and regards,

Suman Choudhary

[Lukas Eder]

It's a table valued function. You can use it in the FROM clause of your query. How else would you want to use it?

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/CAE%3DEzhXH36VYyz_3uYQFdduONYxoGkvq-jLTcn_1topWN%2BP7fg%40mail.gmail.com.