# Display RefCursor in Toad 13

**URL:** <https://forums.toadworld.com/t/display-refcursor-in-toad-13/45556>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [February 6, 2019, 10:55pm UTC](https://forums.toadworld.com/t/display-refcursor-in-toad-13/45556 "2019-02-06T22:55:28Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![karene](https://avatars.discourse-cdn.com/v4/letter/k/b5a626/32.png) [@karene](https://forums.toadworld.com/u/karene)\
**Post date:** [February 6, 2019, 10:55pm UTC](https://forums.toadworld.com/t/display-refcursor-in-toad-13/45556/1 "2019-02-06T22:55:29Z")

</div>

Just like this question: [Display results Stored procedure resturns SYS\_REFCUR](https://forums.toadworld.com/t/display-results-stored-procedure-resturns-sys-refcur/39441).

However, in Toad 12, it would bring up the results grid without any double-clicking on the word (CURSOR). And therefore, I could run the procedure with different parameters, and then go back and forth between the results. I THOUGHT that worked for me last week, after I’d upgraded to Toad 13. It doesn’t now. Now I get a free-floating box that has to be dismissed before I can get back to my Toad instance, after double-clicking on the word and waiting for my results.

Since it worked better in 12 (better than the answer to the linked question), that must still be there. I just can’t find it. How do I get the results grid directly, and in a pinned window within the application?

---

<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:** [February 6, 2019, 11:02pm UTC](https://forums.toadworld.com/t/display-refcursor-in-toad-13/45556/2 "2019-02-06T23:02:18Z")

</div>

You can obtain your cursor in an anonymous block and assign it to a bind variable. When you execute Toad will prompt for the variable’s type/value. Set its type to Cursor and click OK. Results will show in the normal Data Grid.

Example function:

```sql
CREATE OR REPLACE FUNCTION return_cur
    RETURN SYS_REFCURSOR
AS
    cur SYS_REFCURSOR;
BEGIN
    OPEN cur FOR SELECT * FROM user_tables;

    RETURN cur;
END;

```

Example call…

```sql
BEGIN
    :cur := return_cur;
END;

```

When prompted, set Type to cursor…

![image](https://global.discourse-cdn.com/quest/original/2X/a/ac58c288d8471f6f21b71362bd727e4196937e23.png)

Results shown in the grid…

![image](https://global.discourse-cdn.com/quest/original/2X/7/7ee4d3575db9dd384a0a76ef2f5bf4e5194dec57.png)

---

<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:** [February 6, 2019, 11:13pm UTC](https://forums.toadworld.com/t/display-refcursor-in-toad-13/45556/3 "2019-02-06T23:13:51Z")

</div>

It took me a minute to remember what the change was and looking back at Toad 12 you are correct, cursors did show in their own grid by default when executing PL/SQL. In older Toad your only option for getting out/return values (excluding cursors) was to use DBMS output. The change was made to consolidate all output to a common area in a non-plain text format and support newer features like creation of unit tests from PL/SQL execution results.
