Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Pass-through query drops each 256th character?
I will be forever in debt to the person who provides a solution to this problem*:
I am trying to execute the following pass-through query (in Access 2.0) against an Oracle (7.3.4) database:
SELECT field1 FROM tablename
Pretty simple, eh? OK, field1 is defined as varchar(2000) and contains a lot of text, frequently the full 2000 characters. When I run the query, every 256th character in field1 is dropped. That is, if field1 contained:
"blah blah blah......this asterisk * is character 256......blah blah
blah"
then the result of the query would be:
"blah blah blah......this asterisk is character 256.......blah blah
blah"
If I open the table (as an attached table) in datasheet mode, the data looks fine. If I run a standard Jet query (instead of pass-through), the data looks fine. If I use ODBCTest to run the Oracle SQL, the data comes back fine. It only seems to happen when the query is a pass-through. If the field has exactly 256 characters, the last one will be dropped; if it has 2000 characters, every 256th will be tossed. This also affects fields defined as Oracle type LONG (this is like a Memo for you Access people).
Note: the actual query causing me problems is significantly more complex than this example and due to that and other reasons, I MUST use a pass-through query so please don't suggest "Just use a Jet query".
OK, so, has anybody seen this before? Any solutions?
Thanks in advance!
*When I say "I will be forever in debt to" I mean "I will not say nasty things about".
== == Mike deFreitas == Whistler Computing, LLC == (Remove the 'NOSPAM' from my address when replying) ==Received on Tue Aug 11 1998 - 00:00:00 CDT
![]() |
![]() |