manipulating LONGs

I know that the LONG datatype can be used to store variable length character data up to 2 GB.

When retrieving data from a column of type LONG in a Pro*C program, I must declare a buffer large enough to hold the data. I could

(i) declare an enormous buffer and work with that or

(ii) declare a buffer that I think is large enough and check
for truncation using the indicator variable and resize the buffer as required.

Actually, I don't want to do either of these. I would like to fetch the LONG data in chunks, say 2k at a time. And for that matter, I would like to be able to put data into a LONG column in chunks.

Is this possible? Any elegant work-arounds?

Thanks in advance,

Lincoln Scott   Received on Thu Aug 04 1994 - 11:50:34 CEST