This is part of The Pile, a partial archive of some open source mailing lists and newsgroups.
Subject: Loading jpg images into Oracle 7.3.4
From: "Vincent F. Melody" <vmelody@saintmarys.edu>
Date: Thu, 10 Aug 2000 16:09:12 -0500
I need some help I a trying to find a way to load a jpeg image from
a file into a long raw field in an oracle database. I found some
information in the Perl cookbook in chapter 8.11. What I am not quite
sure of is how perl is storying the data. Is there a way to store an
entire file as a single variable so that I can insert it into an oracle
table?
===
Subject: RE: Loading jpg images into Oracle 7.3.4
From: "Tim Harsch" <harsch1@llnl.gov>
Date: Thu, 10 Aug 2000 14:23:47 -0700
local $/;
$scalar = <FILE>;
}
-or-
$scalar = join( '', <FILE> );
I don't know first hand but you might be better using BLOB than LONG RAW.
Not certain if they have BLOBs in 7.3.
===
Subject: RE: Loading jpg images into Oracle 7.3.4
From: "Douglas Wilson" <dougw@racesearch.com>
Date: Thu, 10 Aug 2000 15:55:38 -0700
Original Message-----
> From: dbi-users-bounce@isc.org [mailto:dbi-users-bounce@isc.org]On
> Behalf Of Tim Harsch
> Sent: Thursday, August 10, 2000 2:24 PM
> To: Vincent F. Melody; dbi-users@isc.org
> Subject: RE: Loading jpg images into Oracle 7.3.4
>
>
>
> {
> local $/;
>
> $scalar = <FILE>;
> }
or
read FILE, $scalar, -s FILE;
===
Subject: RE: Loading jpg images into Oracle 7.3.4
From: Ilya Sterin <ideas_pc@usa.com>
Date: Fri, 11 Aug 2000 08:36:55 -0400 (EDT)
You use place holders. First read the file and assign the image code to
scalar then insert. You also might have to unpack("H*", ) or not. Also use
read_blob when extracting. For complete examples see README.longs in the
DBD::Oracle package.
===