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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

283 views