<div>
It progressed even farther thanks to that adjustment but still got the error. I went down as a far a 30 and a high as 500 just to be sure. I got a 'out of memory expanding memory stream' when I went down to 50 ad 30. Any additional suggestions?
</div>


It progressed even farther thanks to that adjustment but still got the error. I went down as a far a 30 and a high as 500 just to be sure. I got a 'out of memory expanding memory stream' when I went down to 50 ad 30. Any additional suggestions?

<div>
I reduced the OCI Array Buffer size down to 10 and it worked.... thank you!<br />

</div>


I reduced the OCI Array Buffer size down to 10 and it worked.... thank you!


<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I am trying to run a stored procedure in Toad and print the results in the output window to save as a text file. The procedure executes but gives me an &quot;Out of Memory&quot; error before finishing the print results portion. I tried spooling via SQL*Plus but the output doesn't look anything like it's supposed to. &nbsp;Please see my syntax below...<br />
<br />
<br />
--Original syntax... Executed in Toad but received a 'out of memory' error while printing results<br />
Variable Results refcursor;<br />
Execute db_name.p_GetHostMatchStag<wbr />e (:Results);<br />
Print Results;<br />
<br />
-- Executed in SQL*Plus using this syntax to spool the results but output is incorrect<br />
Spool c:\output.txt<br />
Variable Results refcursor;<br />
Execute db_name.p_GetHostMatchStag<wbr />e (:Results);<br />
Print Results;<br />
Spool off<br />
<br />
&nbsp; &nbsp; 
</div>
</div>


Hello,

I am trying to run a stored procedure in Toad and print the results in the output window to save as a text file. The procedure executes but gives me an "Out of Memory" error before finishing the print results portion. I tried spooling via SQL*Plus but the output doesn't look anything like it's supposed to.  Please see my syntax below...


--Original syntax... Executed in Toad but received a 'out of memory' error while printing results
Variable Results refcursor;
Execute db_name.p_GetHostMatchStage (:Results);
Print Results;

-- Executed in SQL*Plus using this syntax to spool the results but output is incorrect
Spool c:\output.txt
Variable Results refcursor;
Execute db_name.p_GetHostMatchStage (:Results);
Print Results;
Spool off

    

Toad - Out of Memory error when printing results for a stored procedure

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.