Load Multiple images (BLOBs) into the Database

Hi 61508381-1ef0-48eb-abb0-a47ebc86ab39,

One way would be to use Oracle sqlldr, available with Oracle client and server installs:

Create a file with your images filenames that you want to load, for example:

C:\> dir/b *.jpg *.png > files.txt
C:\> type files.txt

Oracle11g-Architecture.jpg
sql.jpg
ocr.jpg

The directory listing search for jpg and png files found 3 jpg files.

files.ctl control file referencing our list of image files in files.txt:

LOAD DATA
INFILE files.txt
APPEND
INTO TABLE images
FIELDS TERMINATED BY ',' TRAILING NULLCOLS
(
name,
image LOBFILE(name) TERMINATED BY eof
)

Load the data using sqlldr and our control file above:

C:\> sqlldr user/[email protected] control=files.ctl

The filenames and their respective image files data were loaded into the images table.

SELECT name FROM images;
NAME
------------------------------
Oracle11g-Architecture.jpg
sql.jpg
ocr.jpg

3 rows selected.

Hope that helps,

Gaz.