GetOracleDecimal Memory Leak

Question

@GilShalit posted this comment a year ago:

"Well, we have come to distrust ODP (.Net 2.0) after fighting a memory leak (in code we supplied to a customer) in GetOracleDecimal for over a year... Good luck!" – GilShalit Aug 27 '09 at 12:44

How did you solve it?

We have a service that queries an Oracle database every few minutes that is not releasing memory; after some investigation using WinDbg I discovered that this type is piling up in the finalize queue: Oracle.DataAccess.Types.OpoDecCtx.

Here's the line that I think is the problem:

decimal volume = (decimal)OracleDecimal.SetPrecision(reader.GetOracleDecimal(5), 28);

I commented this out and the memory leak disappeared.

Any thoughts will be appreciated - thanks!