Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Pass-through query drops each 256th character?

Pass-through query drops each 256th character?

From: Mike deFreitas <MdeFreitasNOSPAM_at_whistlercomputing.com>
Date: 1998/08/11
Message-ID: <35D05A05.C1126654@whistlercomputing.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US