Toad World® Forums

Cursor output from anonymous block in grid


#1

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


#2

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

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 on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.


#3

Thanks for the reply Michael.


#4

I have one query.

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

Thanks

Nik