Re: Procedure to show and spool all the results

jackfung188_at_gmail.com wrote:

> to further explaining my question, the name of spool file is the same
> as the xx. For example, it is xx.txt when customer id is xx, it is
> abc.txt when customer id is abc, etc..

Do you want a spool file? A physical file sitting on the hard disk? Or to scroll things on the screen from SQL*Plus? Or to scroll things on the screen from a PL/SQL procedure?

You are making this excrutiatingly difficult by bouncing back and forth like a ping-pong ball.

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