I have a problem with executing oracleCommand.ExecuteReader() method. Whatever I try it always returns null and it won't create OracleDatareader object. I'm using ODAC 1120320_x64 for .net 4.0 and timesten112241.win64. Don't sure what to do. Debugger is showing strange thing in OracleConnection object : ConnectionState = Closed, but output of ttStatus shows connection to TimesTen data store and ExecuteNonQuery() command works just fine with or without (in or out) parameters. But when I try to execute some query with multile output such as select *, I can't get any result.
I also have a strange problem with connection.Open() and couldn't find any solution online. When I execute Open() i throws AccessViolationException that can be handled with [HandleProcessCorruptedStateExceptions] attribute, but connection is established after that and my application works fine until I try to instance OracleDataReader object. Thanks in advance!
Here is the code:
OracleCommand select = null;
OracleDataReader reader = null;
select = new OracleCommand(selectStmt, connection);
select.CommandType = CommandType.Text;
reader = select.ExecuteReader(); // this line throws NullReferenceException
object values = new object;
if (values != DBNull.Value)
Console.WriteLine("No rows found.");
catch (Exception e)
Just to mention, I tried it with different queries (pl/sql, plane sql, stored procedure) and all of them works fine in SQL Developer, but not in app.
Yeah, but in My Oracle Support I'm asked to provide serial number and to have purchased product, and I'm only evaluating it for now. I downloaded TimesTen from oracle.com but didn't get any serial key. Is there any other way to get one of those patches? Is there an email address to contact the support or I need to call support agent for my country?
It seems that this solves everything! Still getting AccessViolationException in some strange cases, but connection is now opened and everything works perfect, including DataReader! Thanks a lot and I'll buy you a beer if you are anywhere close to Serbia! :D