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: OCI 8 and Blobs.

Re: OCI 8 and Blobs.

From: <mgogala_at_rocketmail.com>
Date: Sun, 20 Dec 1998 06:03:38 GMT
Message-ID: <75i3vq$cvg$1@nnrp1.dejanews.com>


In article <pMSe2.821$UY2.4963544_at_newsfeed.intelenet.net>,   "Will Hartung" <Will.Hartung_at_msoft.com> wrote:
> Can anyone fill in the blanks?
>
> Can you do something like:
>
> update table set data = :1 where key = :2
>
> or
>
> insert into table(key, data) values (:1, :2)
>
> where data is a BLOB field? All of the example I see are of the nature:
>
> insert into table values (:1, empty_blob());
>
> select data from table where id = :1 for update;
>
> But, it's not clear how I then finish the update.
>
> I've tried allocating a new OCILobLocator, and using OCISetAttr to set the
> locator empty, but I get an invalid handle error on the LobWrite call. These
> invalid handle errors are VERY frustrating.
>
> I'm writing in C++ using MSVC 6.0.
>
> Thanx!
>
> Will Hartung
> (willh_at_msoft.com)
>
>

I've got it working on SUN Solaris. I can email you the classes and the Makefile, but I don't know much about MSVC and I cannot guarantee it will work. It's about 2500 lines of code dealing with OCI8. Regards,

--
Mladen Gogala

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sun Dec 20 1998 - 00:03:38 CST

Original text of this message

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