Re: Procedure to show and spool all the results

jackfung188_at_gmail.com wrote:
> so, if I just want to display all the (select * from....)results on my
> screen without doing spooling, what would you suggest me to do?
> Actually the reason I am doing this is to verify all my data in
> different tables. I want to get the xx and yy value and display
> everything in the same time.
>
> For example, after I do exec procedureA (xx, yy), I could get all the
> results from the query to display on screen.
>
> thanks

I would suggest you just do SELECT * ... it will absolutely scroll all over your screen. The fact that you are asking this question thus leads to a boat-load of questions with respect to information you have not given us about what it is you are really doing?

If you are trying to do this in a PL/SQL procedure than look at the following demo:
http://www.psoug.org
click on Morgan's Library
click on REF CURSOR
Try the first demo.

This has nothing, however, to do with spooling.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)