Named query output using functions (cursor and temporary table)


i tried to look at the documentation of named queries, but i didn’t find anything useful.
The question is simple: is it possible for a named query to call an oracle funcion that returns a cursor or a temporary table and return this output into a perspective project?

Many thanks in advance!

I haven’t used Oracle in a long time, but I would expect you to be able to put the cursor-returning function in the FROM clause of a SELECT statement to return the rows.