Problem with fetch of LONG data through Oracle ODBC driver 10 or 11g
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?