Oracle csv line size more than 32767 How to generate csv in oracle if it's query result return more than 32767 character per line  in linux shell script
You can't use utl_file, since it has a maximum line length of 32767.
It's possible that sqlplus has a similar limit. If you are tying to 
move data to a different Oracle database you can use data pump. You 
can eve use datapump on a materialized view. If you want to migrate 
to a non Oracle database you can use Perl or heterogeneous services
to create a database connection to mySQL, SQL Server, etc. Then you
won't have to worry about the line length.

UTL_FILE