Problem with MS Oracle Data Provider using Oracle Client 9.2
Hello all,
we are getting an an InvalidOperationException when executing an oracle command from an ASP.NET 2 application (ported from a 1.1 version).
The exception happens only on a specific configuration:
Framework 3.5 -> Microsoft .NET Framework Data Provider for Oracle -> Oracle client 9.2 for Windows -> Oracle server 10.2 for Windows 64 (in cluster)
On another installation with Oracle client 10.2 we don't get any error.
Unfortunately our customer claims to be tied to the 9.2 client, so we have
to find a workaround or show him that there's an actual problem with this configuration.
Our code has this typical pattern:
OracleCommand cmd = new OracleCommand("SELECT * FROM ....");
cmd.Connection=conn;
DataTable t = new DataTable();
OracleDataAdapter oraRead = new OracleDataAdapter(cmd);
oraRead.Fill(t);
0