Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: [oo4o] How to put a NULL value into an Oblob

Re: [oo4o] How to put a NULL value into an Oblob

From: tojo <Tojo_at_hotmail.com>
Date: Fri, 29 Nov 2002 10:14:54 +0100
Message-ID: <MPG.18514e767b8c244a9896d8@news.t-online.de>


In article <slrnaue9ei.c65.root_at_bakka.org>, bakka_at_omatis.com says...
> Hello,
> I'm searching how to set an OBlob object to NULL
> Thanks for your help
>

You can use the Erase method, or straight SQL:

 UPDATE TBL_BLOBDATA SET BLOBFIELD = EMPTY_BLOB() WHERE...

Received on Fri Nov 29 2002 - 03:14:54 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US