Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: OCI 8 and Blobs.
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