Any woraround for this ....?

[Muthaiah, VSNL]

Hi,   I'm writing a procedure/script for extract the data of all the tables in a schema. When I am trying to spool/write into a file, I am getting the following error.   ORA-20001: -20000ORA-20000: ORU-10028: line length overflow, limit of 255 bytes per line ORA-06512: at "SCOTT.EXTRACT", line 115 ORA-06512: at line 1 First I tried to spool to a file.But got the error line length overflow. I have tried using the UTL_FILE option also. But getting the same error. Can anyone in the list has any work around for this?   Thanks in Advance,     Muths