I am trying to query an Oracle database and keep getting the error:
Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
I have gone through my query and determined that if I remove two columns from the select statment that are both TimeStamp with TimeZone columns that the query executes just fine and returns the appropriate data. Adding in one of the TimeStamp columns as part of the data retrieved throws an exception and the error above is given. Does anyone know why this would happen with TimeStamp columns and all other columns would appear to be fine?
If you're using "normal" ADO and OracleConnection, the timestamp with timezone should be getting cast to OracleTimeStampTZ, not a .NET DateTime. Are you doing that?
Please Mark As Answer posts that helped you.
"If we learn from our mistakes, I should be brilliant by now."
MCTS - .NET Framework 2.0: Web Applications