Re: Inserting a BLOB into an Oracle BLOB field.

Article View: comp.lang.java.databases

Article #23

Back to comp.lang.java.databases Previous Next

#23

From: Sudsy
Date: Mon, 24 Mar 2003 15:34

19 lines
1700 bytes

"BigJef" <tmp-05@pandora.be> wrote in message news:<HYlfa.3434$t_2.317@afrodite.telenet-ops.be>...
> Hi,
> 
> How can I insert a new record in an Oracle table with a BLOB field. I'm
> especially interessed in the way to get a BLOB into this field using JDBC.
> 
> We use Oracle 8.1.7.
> 
> Tnx in advance,
> 
> 
> Kind regards,
> 
> BigJef

It's convoluted. Go to www.sudsy.net, click on the Technology
button and select the article title "Using CLOBs with Oracle".
The information also applies to BLOBs. This is distilled from
the documentation provided directly by Oracle, BTW.

Technical Details

Message-ID: <3c836f4e.0303240734.59f0421@posting.google.com>

Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!postnews1.google.com!not-for-mail

References: <HYlfa.3434$t_2.317@afrodite.telenet-ops.be>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10a146,e8c23f2579c7b93f
X-Google-Attributes: gid10a146,public
X-Google-Thread: fcea4,e8c23f2579c7b93f
X-Google-Attributes: gidfcea4,public
X-Google-Thread: 107d46,e8c23f2579c7b93f
X-Google-Attributes: gid107d46,public
X-Google-ArrivalTime: 2003-03-24 07:34:38 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: bitbucket44@hotmail.com (Sudsy)
Newsgroups: comp.lang.java.databases,comp.lang.java.programmer,be.comp.programming
Subject: Re: Inserting a BLOB into an Oracle BLOB field.
Date: 24 Mar 2003 07:34:37 -0800
Organization: http://groups.google.com/
Lines: 19
Message-ID: <3c836f4e.0303240734.59f0421@posting.google.com>
References: <HYlfa.3434$t_2.317@afrodite.telenet-ops.be>
NNTP-Posting-Host: 216.221.84.254
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1048520078 1894 127.0.0.1 (24 Mar 2003 15:34:38 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 24 Mar 2003 15:34:38 GMT

Reply to Parent Message