Re: LOB to BFILE

From: <ewall_at_my-dejanews.com>
Date: Wed, 22 Jul 1998 06:10:54 GMT
Message-ID: <6p3vpe$dlt$1@nnrp1.dejanews.com>

I am also writing TIFF images into a LONG RAW field under Oracle8. According to Oracle, the only way to do this is to break the data up into 32K chunks at the OCI level. I will most like use RogueWave's DBTools.h++ for Oracle which abstracts this for the user. The code for doing this amounts to something like:

...
unsigned char* tiffData = new unsigned char[TIFFSIZE]; ...
// Blob wrapper class provided by RogueWave RWDBBlob myBlob( (void*)tiffData, sizeof_tiffData ); ...
insert << myBlob;

-Eric

In article <6n8cra$aon$1_at_nnrp1.dejanews.com>, tcreedon_at_hpti.com wrote:
>
> I'm trying to write a LOB , in this case a tiff image from an internal long
> raw field to the file system. I have looked a DBMS_LOB, which will not work
> because of the BFILE read only attribute, and DBMS_OUTPUT, which seams to be
> limited to 255 bytes. Has anyone run into this problem or does any one have
> a solution. Any pointers in the right direction would be greatly appreciated
>
> Tom
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Jul 22 1998 - 01:10:54 CDT