Re: Oracle8 and ODBC SQLGetData for LONG RAW

From: txm <txm_at_best.com>
Date: Fri, 12 Mar 1999 16:06:54 -0800
Message-ID: <36e9ac12$0$208@nntp1.ba.best.com>

I just found Oracle ODBC document and it says:

---

---

X. Long Raw Data via ODBC
There is a 32 KB limitation on the size, (per chunk) of data blocks read to/from a long
raw column in the RDBMS using a combination such as SQLParamData() and SQLGetData()/SQLPutData() to retrieve the LONG/LONG RAW data.

---

---

Looks like I'm stuck. Does anybody know any workaround?

Actually I cannot understand "per chunk" above. Can I repeat reading "chunk"?

Thanks.

txm

txm wrote in message <36e8d3ed$0$227_at_nntp1.ba.best.com>...
>Hi, all
>
>We are using Oracle8(8.0.4.0.0) and ODBC Driver(8.0.4.4.0) from Oracle. We
>have a table, which has a LONG RAW column. When we insert 188KB data to the
>table and then we read it through ODBC, it's truncated to 57KB. At ODBC
>level, there is no errors. I cannot tell which operation fails, inserting
or
>selecting but because everytime we read the data, it returns different size
>of data(still around 57KB), I suspect SQLGetData. Does anybody have any
>idea?
>
>Thanks in advance.
>
>
>txm
>
>
>
Received on Fri Mar 12 1999 - 18:06:54 CST