How can I read/write a CLOB using Pro*C ?

Hi,

I managed to read/write a CLOB by specifying:

OCIClobLocator *locator;
varchar *data;
data = (varchar *) malloc( 2 + size );
data->len = (short)size;
strcpy( data->arr, my_data );
EXEC SQL LOB WRITE ONE :size FROM :data INTO :locator;

But, the varchar isn't sufficient to hold my_data, hence I tried to use LONG VARCHAR, here the len field is an integer rather than a short. But the declaration:

long varchar *data;

is illegal; what's missing?

Thanx, Peter Received on Fri Jun 09 2000 - 00:00:00 CDT