Re: Handling of BLOBs in Oracle 7 with Pro*(C/Ada) ?

From: Chuck Fetters <cfetters_at_iac.net>
Date: 28 Mar 1995 20:29:56 -0500
Message-ID: <3lad6k$pic_at_wabash.iac.net>

Dave Mausner (d-mausner_at_nwu.edu) wrote:

: In article <3ku0j1$s88_at_inrou.erno.de>, aschulz_at_erno.de says...

: >How do you insert/update such large fields with embedded SQL
: >from host variables/files ? Let's assume you have to insert
: >a file of some MB into the database :
 

: the best available method is to allocate the entire blob in memory : and then insert it; there is no piecewise insertion capability.

I can think of one other alternative. Assumming that your code is written in C, you might be able to use the memmap function. It lets you treat a file as if it were an address in your process's memory space. Sorry, I'm not up on standards, so I don't know if this function is widely available. I have seen it on SUN and HP platforms.

Carol Fetters Received on Wed Mar 29 1995 - 03:29:56 CEST