Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem with fetch of LONG data through Oracle ODBC driver 10 or 11g

PavolAlcoholFeb 17 2012 — edited Feb 20 2012
Hello everybody

I've got a small VB6 application reading data from one Oracle table through Oracle ODBC drivers.
This table MyTable contains one column "AdditionalInfo" of type LONG.
When I execute some query like SELECT ID, Name, State, AdditionalInfo FROM MyTable I got all data from this table but last selected column contains wrong data.
In other words, the texts from this column are joined to an incorrect rows.

Here is short example:

Real data in table are:
ID,Name,State,AdditionalInfo
1, 'Name1',1,'text1'
2, 'Name2',1,'text2'
3, 'Name3',1,'text3'

and I got following data
1, 'Name1',1,'text2'
2, 'Name2',1,'text3'
3, 'Name3',1,'text1'

That means that last column contain incorrect text from another rows.

I found out that this problem occurs when I use Oracle ODBC 10.2g or 11g, but work with driver 9.2

Can somebody explain me where can be problem?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 19 2012
Added on Feb 17 2012
2 comments
286 views