# Display results Stored procedure resturns SYS\_REFCUR

**URL:** <https://forums.toadworld.com/t/display-results-stored-procedure-resturns-sys-refcur/39441>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [May 9, 2017, 7:54am UTC](https://forums.toadworld.com/t/display-results-stored-procedure-resturns-sys-refcur/39441 "2017-05-09T07:54:23Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![mourad.bilog](https://avatars.discourse-cdn.com/v4/letter/m/d26b3c/32.png) [@mourad.bilog](https://forums.toadworld.com/u/mourad.bilog)\
**Post date:** [May 9, 2017, 7:54am UTC](https://forums.toadworld.com/t/display-results-stored-procedure-resturns-sys-refcur/39441/1 "2017-05-09T07:54:23Z")

</div>

Hello everybody,

I'm using Toad 12.10 and Oracle 11 64 bits. I've a package of stored procedure and when I execute a procedure that returns a sys\_refcursor nothing is displayed as shown below

 ![toad_result.png](https://global.discourse-cdn.com/quest/original/2X/b/b5b68a1f6214f255791bd8ebdf21ef5223d92442.png)

Note that I've shoosen to display results in a grid as indicated below

 ![result_options.png](https://global.discourse-cdn.com/quest/original/2X/d/df10b1003fa216c455f2c7c12b6fd51646a37b04.png)

Can anyone tell me were I'm wrong and how to resolve this problem.

Regards.

---

<div class="post-metadata">

**Author:** ![mstaszew](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mstaszew/32/23_2.png) [@mstaszew](https://forums.toadworld.com/u/mstaszew)\
**Post date:** [May 9, 2017, 8:06am UTC](https://forums.toadworld.com/t/display-results-stored-procedure-resturns-sys-refcur/39441/2 "2017-05-09T08:06:33Z")

</div>

Double click the cell that says (CURSOR) and you should see a popup grid that allows you to scroll through the results.

---

<div class="post-metadata">

**Author:** ![damir.vadas\_250](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/damir.vadas_250/32/37_2.png) [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\
**Post date:** [May 10, 2017, 3:34am UTC](https://forums.toadworld.com/t/display-results-stored-procedure-resturns-sys-refcur/39441/3 "2017-05-10T03:34:33Z")

</div>

I work in Toad for more than 12 years, but cannot find your advice Michael.

Could you download pic, highlight your “cursor cell” and upload her back?

P.S.

If you thought “Cursor” label of group component, then i would prefere label than cell.Otherwise still do not get it where?

---

<div class="post-metadata">

**Author:** ![GTDG](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gtdg/32/140_2.png) [@GTDG](https://forums.toadworld.com/u/GTDG)\
**Post date:** [May 10, 2017, 4:18am UTC](https://forums.toadworld.com/t/display-results-stored-procedure-resturns-sys-refcur/39441/4 "2017-05-10T04:18:37Z")

</div>

This is window is new in the last couple of releases.

 ![cursor.jpeg](https://global.discourse-cdn.com/quest/original/2X/a/ad5d7225f05225feba31bf4f7cc833f9c8763853.jpeg)

---

<div class="post-metadata">

**Author:** ![mstaszew](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mstaszew/32/23_2.png) [@mstaszew](https://forums.toadworld.com/u/mstaszew)\
**Post date:** [May 10, 2017, 4:20am UTC](https://forums.toadworld.com/t/display-results-stored-procedure-resturns-sys-refcur/39441/5 "2017-05-10T04:20:09Z")

</div>

In the OP's first screenshot the main node for the cursor argument has a cell in the output column having text (CURSOR). Double click there. That could be visualized differently to be clearer.

On May 10, 2017, at 6:35 AM, Damir Vadas [bounce-damirvadas\_250@toadworld.com](mailto:bounce-damirvadas_250@toadworld.com) wrote:

> **[RE: Display results Stored procedure resturns SYS\_REFCUR](http://www.toadworld.com/products/toad-for-oracle/f/10/p/32548/65788#65788)**

> Reply by Damir Vadas  
> I work in TOad for more than 12 years, but cannot find your advice Michael.

> To reply, please reply-all to this email.
> 
> [Stop receiving emails](http://www.toadworld.com/products/toad-for-oracle/f/10/t/32548?subscribe=false) on this subject.
> 
> Or [  
> Unsubscribe from Toad for Oracle Forum](http://www.toadworld.com/products/toad-for-oracle/f/10?subscribe=false) notifications altogether.
> 
> Toad for Oracle - Discussion Forum

> [Flag](http://www.toadworld.com/products/toad-for-oracle/f/10/p/32548/65788?AbuseContentId=d4b0e629-5861-464b-890b-2320ad3afcbb&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true)  
> this post as spam/abuse.

---

<div class="post-metadata">

**Author:** ![damir.vadas\_250](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/damir.vadas_250/32/37_2.png) [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\
**Post date:** [May 10, 2017, 4:24am UTC](https://forums.toadworld.com/t/display-results-stored-procedure-resturns-sys-refcur/39441/6 "2017-05-10T04:24:09Z")

</div>

Thx Michael.
