# Cursor output from anonymous block in grid

**URL:** <https://forums.toadworld.com/t/cursor-output-from-anonymous-block-in-grid/30975>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [September 18, 2014, 3:20am UTC](https://forums.toadworld.com/t/cursor-output-from-anonymous-block-in-grid/30975 "2014-09-18T03:20:29Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Nik16](https://avatars.discourse-cdn.com/v4/letter/n/94ad74/32.png) [@Nik16](https://forums.toadworld.com/u/Nik16)\
**Post date:** [September 18, 2014, 3:20am UTC](https://forums.toadworld.com/t/cursor-output-from-anonymous-block-in-grid/30975/1 "2014-09-18T03:20:29Z")

</div>

Hi All,

Anyone has idea, if there is a way we can return cursor output from anonymous blocks in data grid(UI) in toad; just like we have when we execute cursors in procedure.

Thanks

Nik

---

<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:** [September 18, 2014, 6:33am UTC](https://forums.toadworld.com/t/cursor-output-from-anonymous-block-in-grid/30975/2 "2014-09-18T06:33:17Z")

</div>

Here's an example. Run the following, in the variables dialog that shows set the datatype to cursor.

begin

```
open :cur for select * from user_objects;

```

end;

On 09/18/2014 06:20 AM, Nik16 wrote:

> **[Cursor output from anonymous block in grid](http://www.toadworld.com/products/toad-for-oracle/f/10/t/22779.aspx)**

> Thread created by Nik16  
> Hi All,

> Anyone has idea, if there is a way we can return cursor output from anonymous blocks in data grid(UI) in toad; just like we have when we execute cursors in procedure.

> Thanks

> Nik

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

> [Flag](http://www.toadworld.com/products/toad-for-oracle/f/10/t/22779.aspx?AbuseContentId=8dfaf24a-6f3d-43b5-b14a-4f39e4421c0b&AbuseContentTypeId=46448885-d0e6-4133-bbfb-f0cd7b0fd6f7&AbuseFlag=true)  
> this post as spam/abuse.

> ![](https://global.discourse-cdn.com/quest/original/3X/5/0/50b30fd5f87c85fe5cba2635cb83316ca71250d7.gif)

---

<div class="post-metadata">

**Author:** ![Nik16](https://avatars.discourse-cdn.com/v4/letter/n/94ad74/32.png) [@Nik16](https://forums.toadworld.com/u/Nik16)\
**Post date:** [September 18, 2014, 11:22pm UTC](https://forums.toadworld.com/t/cursor-output-from-anonymous-block-in-grid/30975/3 "2014-09-18T23:22:02Z")

</div>

Thanks for the reply Michael.

---

<div class="post-metadata">

**Author:** ![Nik16](https://avatars.discourse-cdn.com/v4/letter/n/94ad74/32.png) [@Nik16](https://forums.toadworld.com/u/Nik16)\
**Post date:** [September 18, 2014, 11:27pm UTC](https://forums.toadworld.com/t/cursor-output-from-anonymous-block-in-grid/30975/4 "2014-09-18T23:27:01Z")

</div>

I have one query.

Also is there a way to bind variables when executing block as script?

Thanks

Nik