EOutOfMemory Error

[CAC]

PL/SQL developer crashes when fetching more than 260K records from the database. I have increased the paging file size but it is still crashing.

Version : 7.5.1.0
Date : Sun, 28 Apr 2019 18:59:38 -0400
OS : Microsoft Windows 10 (64 bit)
RAD : BDS 16.0
Dump : $83 $C0 $0C $5A $C7 $40 $F8 $01 $00 $00 $00 $89 $50 $FC $66 $C7 $04 $50 $00 $00 $66 $C7 $40 $F6 $02 $00 $8B $15 $04 $39 $BE $01
Section : ExceptionHandlerHook
Descr :

Address : $0040C34B - [00400000] plsqldev.exe - System - - _NewUnicodeString - 0[19]
Module : plsqldev.exe
Exception : EOutOfMemory
Message : Out of memory
Call Stack : 00 $0040C34B - [00400000] plsqldev.exe - System - - _NewUnicodeString
01 $00764783 - [00400000] plsqldev.exe - ExceptionLog7 - - FullInternalErrorReport - 693[1591]
02 $00521FF0 - [00400000] plsqldev.exe - EBase - - InternalErrorSet - 1586[572]
03 $007564F1 - [00400000] plsqldev.exe - EInject - - ExceptionHandlerHook - 636[205]
04 $77E709EE - [77E10000] ntdll.dll - ntdll - - (possible EtwRegisterTraceGuidsW+670)
05 $77E73B7A - [77E10000] ntdll.dll - ntdll - - (possible RtlUnwind+458)
06 $77E7CD81 - [77E10000] ntdll.dll - ntdll - - (possible KiUserExceptionDispatcher+33)
07 $005A2270 - [00400000] plsqldev.exe - EThreadsManager - - RaiseExceptionHook - 1608[312]
08 $00756163 - [00400000] plsqldev.exe - EInject - - RaiseExceptionProcHook - 482[107]
09 $0040A36E - [00400000] plsqldev.exe - System - TObject - NewInstance
0A $004070D6 - [00400000] plsqldev.exe - System - - ErrorAt
0B $0040A36E - [00400000] plsqldev.exe - System - TObject - NewInstance
0C $00AB7804 - [00400000] plsqldev.exe - TSGrid - TtsCellPropSet - CreateElement - 16786[20]
0D $00AB6EED - [00400000] plsqldev.exe - TSGrid - TtsCustomPropSet - SetProperty - 16626[181]
0E $00AB79DC - [00400000] plsqldev.exe - TSGrid - TtsCellPropSet - SetProperty - 16859[100]
0F $00ACDE71 - [00400000] plsqldev.exe - TSGrid - TtsBaseGrid - SetCellCenterPicture - 26710[117]
10 $018AE80B - [00400000] plsqldev.exe - ChildForm - TChildForm - SetCellColor - 11005[423]
11 $018B3795 - [00400000] plsqldev.exe - ChildForm - TChildForm - CopyQueryRowToGrid - 12913[2113]
12 $015482E8 - [00400000] plsqldev.exe - SQLUnit - TSQLForm - FillGridRow - 2273[576]
13 $004FBFD1 - [00400000] plsqldev.exe - System.Classes - - CheckSynchronize
14 $007156C2 - [00400000] plsqldev.exe - Vcl.Forms - TApplication - WndProc
15 $004FFC28 - [00400000] plsqldev.exe - System.Classes - - StdWndProc
16 $771DBF19 - [771A0000] user32.dll - user32 - - (possible AddClipboardFormatListener+1177)
17 $771D83E5 - [771A0000] user32.dll - user32 - - (possible DispatchMessageW+2421)
18 $771D7C99 - [771A0000] user32.dll - user32 - - (possible DispatchMessageW+553)
19 $771D7A7B - [771A0000] user32.dll - user32 - - DispatchMessageW
1A $00715FE3 - [00400000] plsqldev.exe - Vcl.Forms - TApplication - ProcessMessage

LastAddr :
LastModule :
LastException :
LastMessage :
Call Stack :

ActiveObj : (EOutOfMemory) Out of memory
ActiveAddr : $0040A373 - [00400000] plsqldev.exe - System - TObject - NewInstance - 0[15]

 

[Marco Kalter]

Did this error occur in the SQL Window for a query have a large result set? If so, you should preferably use the "Export Query Results" button to the right of the SQL editor (before executing the query) or on the result set toolbar (after executing a query and fetching the first results). This way the query results will directly be written to a file, without any memory overhead.