OracleCommand memory leak - inserting parameterized arrays...
Hello,
I have a batch .net Application that bulk inserts into a table using parameterized arrays sent to a stored proc.
The application psuedo looks like this:
For each report
-Retrieve 14 K rows of data
-create arrays based on data
-specify bind count
-connect
-OracleCommand.ExecuteNonQuery <-- THIS IS WHERE THE MEMORY JUMPS AND IS NEVER RELEASED
-connection.close()
-connection.dispose()
-OracleCommand.dispose()
Next report
At this point I am very near causing an System.OutOfMemoryException
If I add any more reports to the process I am sure it will happen.
IS THERE A WAY TO RECLAIM THIS MEMORY OTHER THAN HOW I AM DOING IT? I HAVE TRIED MULTIPLE WAYS (using OracleCommand..., OracleCommand = nothing, OracleCommand.dispose) BUT THIS HAS NOT MADE ANY DIFFERENCE.
Thanks,
Joe