Reading huge data from oracle 8i

[sumitrishi]

I m trying to read data from oracle 8i . The Easy Sql.vi behaves erratically . It returns data for some tables and does not in case of others. Please assist me in resolving this issue.

[Feroz]

Hi,

Please check your data types are the same. Here's a link to a Knowledge Base that may be useful to you:
Querying Data of Type Numeric from Oracle Returns Incorrect Values

Feroz

[Crystal]

The Easy SQL VI is a part of the old SQL Toolkit ver. 3.0 and earlier or it's a compatibility VI in the current Database Connectivity Toolset. Either way, by using this old VI, it means you are probably using an old ODBC driver either from Merant or Microsoft. Both these drivers had bugs reading large (>8kB) binary data from Oracle. I recommend using the current Database Connectivity Toolset VIs and a recent OLE DB provider or ODBC driver from Oracle. Oracle does a much better job writing their own drivers than another company such as Microsoft or Merant.

Usually when data isn't returned correctly, it's a driver issue. Please include the versions and manufactures of the drivers you use whenever you have database issues.

Thanks,
Crystal