From: "Brett McKenzie" Subject: Re: Oracle ODBC Drivers. Long Raws. 32K Limit ?? Date: 1997/09/09 Message-ID: <01bcbd4e$11096b60$0101a8c0@fleagle>#1/1 References: <341072ac.1851191@news.ftech.net> Organization: McKenzie Solutions Pty Ltd Newsgroups: comp.databases.oracle.server I'm using Delphi 3 with the "Microsoft ODBC driver for Oracle" V2.00.006325 against Oracle 8, and have noticed a limit of 64K for "long raw". One solution I can think of, though I haven't needed to resort to it, is to break up your blob into 32K chunks, and store them in individual rows (one-to-many). Its far from ideal, but it would work. When you read the data back you concatenate the chunks back into the real data field. Brett mckenzie@magna.com.au Surjit Hunjan wrote in article <341072ac.1851191@news.ftech.net>... > Hi > > I'm Oracle DBA working on NT3.51, Oracle 7.2.2.11. The development > team are having a problem which we would be greateful for some > advice/pointers > > The developers are using VB4 and Oracle 2.0.3.1.1 Odbc drivers. The > problem arises when the want to manipulate data stored in Long Raws. > Below 32K they seem to have no problem, However > 32K they get data > curruption. > > We have spoken to Oracle and they said thier drivers will not support > fully support Blobs/Long Raws until they end of 1997/ early 98. > > We would like to know how if anybody else had similar problems and > also if there is a solutions or work arounds. > > > Surjit Hunjan > DualAlpha Limited. > > Email: Surjit@dualalpha.co.uk >