Path: news.easynews.com!easynews!crtntx1-snh1.gtei.net!nycmny1-snh1.gtei.net!news.gtei.net!bloom-beacon.mit.edu!newsfeed.stanford.edu!sn-xit-01!sn-post-01!supernews.com!corp.supernews.com!not-for-mail
From: "Daniel A. Morgan" <damorgan@exesolutions.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: BLOB, CLOB
Date: Sun, 05 May 2002 14:20:14 +0100
Organization: EXE
Message-ID: <3CD5318E.B08C61CE@exesolutions.com>
X-Mailer: Mozilla 4.79 [en] (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
References: <3cd530d1@news.uni-linz.ac.at> <3cd54d6c$0$8511$cc9e4d1f@news.dial.pipex.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Cache-Post-Path: yasure!unknown@splish28.drizzle.com
X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/)
X-Complaints-To: newsabuse@supernews.com
Lines: 37
Xref: easynews comp.databases.oracle.server:145978
X-Received-Date: Sun, 05 May 2002 14:18:56 MST (news.easynews.com)

Niall Litchfield wrote:

> look into dbms_lob which will allow you to do this .
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> "Simon Walchshofer" <simon.walchshofer@students.uni-linz.ac.at> wrote in
> message news:3cd530d1@news.uni-linz.ac.at...
> > Hi!
> >
> > Is it possible to insert for example a picture into a table with one
> > sql-insert statement?
> >
> > e.g.
> > create table myLob (id number, picture clob);
> >
> > insert into myLob values (1, ??????????);
> >
> > Is there a possibility to specify the file-path directly in the
> > insert-statement??
> >
> > THX
> > Simon
> >
> >

Please correct me if I am wrong but it is not possible, DBMS_LOB, or not.
Every time I have gotten it to work I have inserted a row with an
EMPTY_BLOB() reutrning ROWID and then locked it then updated it with the
image.

I would be interested in seeing an example that bypasses that requirement.

Daniel Morgan