JOOQ supportability for the stored procs which returns SET OF RECORD

Skip to first unread message

suman choudhary

Apr 12, 2024, 2:57:37 AMApr 12

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

Apr 12, 2024, 2:59:42 AMApr 12
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
To view this discussion on the web visit
Reply all
Reply to author
0 new messages