Re: Retrieving length of data in LONG RAW column

I am not sure if this helps. I use the long varraw to store and fetch data from oracle using the following struc in proC:

typedef struct {

    int len;
    char buf[MAX_FILE_SIZE];
} long_varraw;

where len is the size of the data.

Brad Maxwell wrote:
>
> Can anyone tell me the best way using PRO/C to find out the size of the
> data that was written to a LONG RAW column?
>
> The only way I know to do it currently is to allocate an insufficient
> amount of space in the select descriptor and fetch. Once the fetch is
> executed, Oracle will tell you that there was data truncation and tell
> you how many bytes were needed. Then you can reallocate the descriptor
> space to that size and have at it again.
>
> This seems like a real pain. Is there a better way?
>
> Thanks,
> Brad
> bcmaxwel_at_ingr.com
 

-- 

Charlene Liang                |  (203) 481-1104 ext. 287
CuraGen Corporation           |
322 E. Main St.               |
Branford, CT 06405            |
cliang_at_curagen.com     |  (FAX) (203) 481-1102