Oracle pipelined table function in JPQL

172 views Asked by At

is there the possibility to include oracle pipelined table function in JPQL query. I tried this

SELECT
   e,
   FUNC.DATE
FROM
   TABLE(MYFUNCTION(:id)) FUNC,
   MyClass e
WHERE
   FUNC.ID = e.id

but I have following error:

unexpected token: TABLE: line 1:58: unexpected token: TABLE
0

There are 0 answers