Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

spool database table data for Java loader program

406672Jul 21 2006

I have a pl/sql program I've written to pull data from my database tables and spool to a csv file for a Java loader program to consume.

This has been working great. My problem now is one field is going from a varchar2(4000) to a clob.

I'm using utl_file which has a 32k limit for the output. What tool can I use to pull a clob field out and spool to a csv file?

any help appreciated.
TIA

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 18 2006

Added on Jul 21 2006

#general-database-discussions

0 comments

286 views