Oracle pipelined table function in JPQL

Asked Jan 28 '16 at 17:57

Active Jun 30 '16 at 00:02

Viewed 151 times

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

edited Jun 30 '16 at 00:02

MT0

asked Jan 28 '16 at 17:57

Fra83

2

JPQL is not SQL. It never uses tables and column names. Always mapped entities and their fields/properties. – JB Nizet Jan 28 '16 at 18:45
2

You could create a view that selects from the pipelined table function, map it to JPQL and use it there I suppose. – Francisco Sitja Jan 28 '16 at 19:58

0 Answers0