Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: [oo4o] How to put a NULL value into an Oblob
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...