Can i use spooling within a loop.
I need to generate dynamic files using spool based on the information from the 'for' loop.
If not possible wats the alternate solution.

Can i use spool within procedure. I think this is not possible.