Re: Making a (big) flat file in plsql.

In article <8e80cdcb.0301150537.2fe4228e_at_posting.google.com>, rmoleveld_at_hotmail.com says...
>
>Hi all,
>
>Known problem for a lot of you I suppose.
>Need to make a flat file in plsql. This goes beyond the 1000000 of
>serveroutput and I don't have utl_file (what can be used for this I
>understand).
>

and it is really the only thing.

You have said "I need to do X, but I cannot use Y". Then, you cannot do X - you want to create a big file with PLSQL -- utl_file is the api for doing that. You would need to use that.

See
http://asktom.oracle.com/~tkyte/flat/index.html

for various methods.

>Need to retrieve thousands of record and put them in a flat file,
>normal recordlenght, about 200.
>No need to display them on screen as long they get in the file.
>Any solution for this????
>
>Will appreciate any help.
>
>Best regards,
>
>Ronald.

--
Thomas Kyte (tkyte@oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp