Re: BLOB handling in Oracle

In article <381fvo$m6s_at_tricbbs.tricbbs.fn.sub.org>, <cg_at_tricbbs.fn.sub.org> writes:
> Path:

swuts!texbell.sbc.com!wupost!news.utdallas.edu!corpgate!bcarh189.bnr.ca!nott!dg bt!netfs.dnd.ca!ub!news.kei.com!news.mathworks.com!europa.eng.gtefsd.com!howlan d.reston.ans.net!xlink.net!xlink100!relay.sedat.de!tricbbs.fn.sub.org!tricbbs.f n.sub.org!not-for-mail
> From: cg_at_tricbbs.fn.sub.org (Cees de Groot)
> Newsgroups: comp.databases.oracle
> Subject: BLOB handling in Oracle
> Message-ID: <381fvo$m6s_at_tricbbs.tricbbs.fn.sub.org>
> Date: 18 Oct 94 21:50:48 GMT
> Organization: TricBBS - Bodensee Linux Support Site
> Lines: 30

We've got the same problem. According to the Oracle people we contacted, Oracle doesn't have a solution.
> NNTP-Posting-Host: localhost.tricbbs.fn.sub.org
>
> (I just started reading the group, but the problem is urgent---please
> don't flame me if it is a FAQ).
>
> I looked to all Oracle manuals to find some hints how one should handle
> BLOBs with Oracle (LONG RAW datatype), but only found the standard
> paragraphs over and over again (no functions, no indexing, ...).
>
> What I need to have is some method to get the size of the field on a fetch,
> allocate the memory, and do the actual fetch in the tailor-made buffer for
> the field---IMHO this is the only way to deal with fields that can grow
> as big as LONG RAW (all other solutions would only impose artificial limits).
>
> I heard other RDBMSes provide such solutions, but I couldn't find anything
> for Oracle. Storing the length of the BLOB into an extra field doesn't
> count, as other applications will be using the database. This would be
> redundant anyway, while Oracle has this size information; at least, that is
> what I understood from the DBA guide.
>
> My problem pertains to v6 and v7, the latter being the more important.
>
> If anyone got a hint, please reply per E-Mail, I'll summarize.
>
> Thanks
>
> Cees
> --
> Cees de Groot, Lake of Konstanz, Germany
> PGP23a: 73 5D BA 7C F8 EF DD 65 56 68 AF BB 2B 58 2C 8B
> Running Windows on a Pentium is like having a brand new Porsche but only
> be able to drive backwards with the handbrake on.
  Received on Thu Oct 27 1994 - 22:31:12 CET