Cursor A can generate a script of select statements (cursor B) that spools
each one to a different file.

Java might also be an option.

Thanks,
Jon Knight

-----Original Message-----
From: Kalimuthu Prabhakaran
[mailto:oracledba-ezmlmshield-x19615767.[Email address protected]
Sent: Miércoles, 02 de Noviembre de 2005 10:06 a.m.
To: LazyDBA Discussion
Subject: Spool into different files but not by using PL/SQL

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


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page