I have an Oracle table with 86 columns most of which are varchar(1000) . Most of the columns are Null, but where there is data, no more than 230 chars but mostly around 30 chars. When I run a 'select * from table', the query runs successfully and returns the required 6000+ rows. However, when running it a second time, it errors out with an 'Out of memory' exception error at 1620 rows.
"System.OutOfMemoryException
Exception of type 'System.OutOfMemoryException' was thrown.
Stack Trace:
at Devart.Data.Oracle.OracleDataReader.a()
at Devart.Data.Oracle.OracleDataReader.Read()
at Quest.Toad.Db.ToadDataAdapter.InternalReadBackground()..."
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center