Hi All,
Having the restriction of not to use dbms_output.put_line or
utl_file, I want to spool several chunks of data into files based on the
following conditions. How can i achieve that.

Cursor A, which will pull 100 or so records from Table A.
Cursor B, which will pull 100 or so records from Table B for every
single records fetched from Cursor A.
So, basically Cursor B is the inner cursor to Cursor A. I want to spool
the result into different files, for each time the inner cursor
executes.
I understand here the restriction i have is not to use the pl/sql to
achieve it. Somehow i need to get it done based on some external checks
and plain sqls and spool commands.
Please throw me your ideas if any,

Thanks in advance,
Prabhakar

Oracle LazyDBA home page