Re: Storing and retrieving images in an Oracle Database

From: Alexey M. Reshetov <real_at_kpbank.ru>
Date: 26 Aug 1998 05:03:19 GMT
Message-ID: <6s04un$jh3$4@home.kpbank.ru>

Jack (jsilvey_at_texas.net) wrote:
: All,

: I need to store and extract images in an Oracle 7.3 database. Any
: suggestions on the best way to do this?

: tia

: Jack Silvey
: Oracle DBA
: Dell Computer Corporation

Try this:

1. CREATE TABLE images ( num NUMBER, image LONG RAW);
2. Create file file.ctl for SQL*Loader: load data infile image.gif "fix 65535" append into table images ( num constant 1, image raw(12345) ) - where 12345 - size in the bytes of the image-file.
3. sqlload userid=scott control=file.ctl bindsize=500000

   ---

Alexey Reshetov
real_at_kpbank.ru Received on Wed Aug 26 1998 - 00:03:19 CDT