Windows Oracle Data Access Components (MOSC)

MOSC Banner

Problem with MS Oracle Data Provider using Oracle Client 9.2

edited Jun 18, 2010 4:49AM in Windows Oracle Data Access Components (MOSC) 1 commentAnswered
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);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center