Error "Out of memory" when executing a query that only returns a small number of rows (4309841)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Error "Out of memory" when executing a query that only returns a small number of rows
Description

When running a query that only returns 600 rows, the following error occurs:
"Out of memory"
How can you suppress the output in the 'Output' window?
Cause

Single statement query was executed using 'Execute as Script'. This sends the results to the output window. These results return column headers and column separators (like scrolling through results in a sqlplus session) in addition to the actual data. If a row has many columns, then even returning a small number of rows could result in a large output (which is in memory)
Resolution

If a single statement is to be executed, use the 'Execute/compile statement at caret' button (F9)

If running a script, you can suppress the output using the sql*plus command SET TERM OFF at the beginning of the script

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title