Toad World® Forums

Question on how to view the result set for a proceedure


I am using toad 10.6 and have inherited a great deal of code that i now need to
fully understand.

I have a few packages that I want to be able to view the result set.

I do not know how to ‘view’ the results.

I have executed the packages but would like to view the dataset.

Greatly appreciate assistance.


I have executed the packages but would like to view the dataset.

And the most common answer is… it depends.

I think for the primary purpose you identified (learning about the code), turning on the debugger would be most useful. That way you can just step through the process flow in the code keeping an eye on the variables and seeing what happens under what conditions.

Roger S.

This communication, including any attached documentation, is intended only for the person or entity to which it is addressed, and may contain confidential, personal and/or privileged information. Any unauthorized disclosure, copying, or taking action on the contents is strictly prohibited. If you have received this message in error, please contact us immediately so we may correct our records. Please then delete or destroy the original transmission and any subsequent reply.

Click “set parameters” button on your Editor toolbar and look at the output
options tab.