Selecting a large database field into a long datatype to write out to file affecting performance

Basically im trying to get selected data from the tables and write this into .csv files in a certain format in ProC. However there are certain fields in tables that come close to around 10 MB of data.
I select this field into a oracle long datatype by allocating the required memory space into a long buffer. example:

char*& str;
LONGSIZE=10000;
str = new char[LONGSIZE + 1];

this works fine for smaller records say around < 1MB however it takes over 1 HR to write out a 10MB field record....hence my problem

Is there anyway of efficiently/speedily getting these large records from the table and writing them out to files!?

Im assuming and would have to concede that it does required the use of a long datatype.

Any ideas would be appreciated.

regards
Ishqi. Received on Wed Oct 30 2002 - 01:30:06 CET