Dynamic spool file name

I need to create files based on data returned from a cursor. I know I can use a variable and the column statement to dynamically set the spool filename in a script. However, I am using cursors in a block and that doesn't seem to work inside the block (I can't do a select in a block). Received on Fri Oct 13 2006 - 11:53:35 CDT