Hello,

D5, BDE, Oracle 8.1.6, Oracle ODBC Driver (So John Pierce doesn't yell at
me).

I'm using TTables (bleh, but that's the architecture for now), I can add a
"Long" field as big as I want, but can't seem to get more  than 469
characters back. in fact, i get a "right truncation" error, and then smoke
and fire. can't get the record with GoToKey, can't use the "ApplyRange"
method, etc.

Blob size is set to 1000, Blobs to cache = 64, but changing these two don't
seem to make much difference anyways.

if you're going to tell me not to use the BDE, then don't bother posting a
response, because that is not an option right now. next release it's GONE, i
promise. right now i have to get this one working.

Steve.

I seem to remember that the Microsoft ODBC driver for Oracle is
preffered/better. There is however a limit (general ODBC design I believe)
of 2000 or 4000 bytes that you can not alter.

hth,
Martin

Stephen,
Use Direct Oracle Access from Allaroundautomation and you'll get all kind of
methods and properties that will allow you to write and retrieve data from
long fields -- up to the 2GB limit.

"Stephen P Volpone" <SVolp...@PrimeTechPA.com> wrote in message
news:3b82db2d$3_1@dnews...

I NEVER YELL AT PEOPLE :)

I wish I could be of more help, but I have limited experience with Oracle ODBC,
and I never use TTables.  But....

Have you downloaded the latest ODBC driver from the Oracle site?  They seem to
change almost weekly.  You might try the same, as has been suggested, with the
Microsoft driver.

Have you tried setting RequestLive to True?  This makes the blob settings in the
BDE irrelevant.

I have heard of people who have retrieved a LONG in a stored procedure, then fed
it back to the front end in pieces, where it is reassembled.

Sorry not to be of more help, and good luck!

John Pierce

Now I remember: go to www.allaire.com and search the knowledge base for
Oracle, they have some solutions there (Cold Fusion based) that use these
tricks to overcome the ODBC limits (they have a lot of problems with
non-native Oracle connections and Cold Fusion in this area).

hth,
Martin