Re: Handling of BLOBs in Oracle 7 with Pro*(C/Ada) ?
Date: 25 Mar 1995 14:34:26 GMT
Message-ID: <3l19li$5cr_at_news.acns.nwu.edu>
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.
>
>Can you pass a file descriptor to Oracle, telling it to read
>data from this file into a BLOB field, or do you need a host
>array of the same size (which may blow your virtual memory)
>to pass the data to oracle?
no interface from file system to database built in to o7. you may store paths instead of blobs, of course, and process the file system details yourself.
>
>Currently, with Oracle 6, the job is to split the binary data
>into 64k chunks and storing them into a table with a long raw
>column and a chunk counter...
the chunk size under o6 was 64k, and under o7 the chunk size is 2G.
other than this, things have not improved very much.
>
>---
>Andreas.Schulz_at_erno.de DASA, Space Infrastructure, Bremen, Germany
>
>
-- Dave Mausner, Sr. Consultant, Braun Technology Group, Chicago.Received on Sat Mar 25 1995 - 15:34:26 CET