We are experiencing OutOfMemory problems when trying to pull large resultsets from the database. We have a resultset with 145 string columns and about 70,000 records. After 1,260 records we get:
Exception of type 'System.OutOfMemoryException' was thrown.
We were able to pull more records (hundreds of thousands) with fewer columns in the resultset.
Is this a known bug? Any potential fix/workaround? We are using a StoredProcedure to return the resultset. Could that be a problem?
This is a sample code (the eror occurs on reader.Read()):
OracleCommand cmd = new OracleCommand("AppBatchQM.getResultSet", conn);
OracleCursor cursor = (OracleCursor)cmd.Parameters["RETURN_VALUE"].OracleValue;
OracleDataReader reader = cursor.GetDataReader();
int count = 0;
while (reader.Read()) count++;
Problem pulling large datasets with OraDirect 4
-
- Posts: 729
- Joined: Thu 13 Dec 2007 10:24