# Named query output using functions (cursor and temporary table)

**URL:** <https://forum.inductiveautomation.com/t/named-query-output-using-functions-cursor-and-temporary-table/44744>\
**Category:** Ignition\
**Created:** [March 22, 2021, 8:38am UTC](https://forum.inductiveautomation.com/t/named-query-output-using-functions-cursor-and-temporary-table/44744 "2021-03-22T08:38:15Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mario.colombo91](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mario.colombo91/32/14148_2.png) [@mario.colombo91](https://forum.inductiveautomation.com/u/mario.colombo91)\
**Post date:** [March 22, 2021, 8:38am UTC](https://forum.inductiveautomation.com/t/named-query-output-using-functions-cursor-and-temporary-table/44744/1 "2021-03-22T08:38:15Z")

</div>

Greetings,

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!

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [March 22, 2021, 12:47pm UTC](https://forum.inductiveautomation.com/t/named-query-output-using-functions-cursor-and-temporary-table/44744/2 "2021-03-22T12:47:49Z")

</div>

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.