<div>
Hi, <br />
please check the following link,<br />
<br />
<a href="https://www.experts-exchange.com/questions/20107625/How-to-change-default-Screen-Buffer-Width-and-Size-in-SQL-Plus.html" rel="ugc">https://www.experts-exchange.com/questions/20107625/How-to-change-default-Screen-Buffer-Width-and-Size-in-SQL-Plus.html</a>
</div>


<div>
Another Link<br />
<br />
<a href="http://download-west.oracle.com/docs/cd/B12037_01/server.101/b12170/ch2.htm" rel="ugc nofollow">http://download-west.oracle.com/docs/cd/B12037_01/server.101/b12170/ch2.htm</a>
</div>


<div>
you can write the output to a text file see the following link.<br />
<br />
<a href="http://forums.oracle.com/forums/thread.jspa?threadID=520445" rel="ugc nofollow">http://forums.oracle.com/forums/thread.jspa?threadID=520445</a>
</div>


<div>
Hi,<br />
<br />
I looked to all the links and it is rather difficult. I don't see directly a solution to my problem.<br />
Know I have one sql file (colldata.sql).<br />
It start with a declare, some cursors , BEGIN some loops over the cursors and END.<br />
<br />
In the loops over the cursors if condition is met I did an dbms_output.put_line.<br />
<br />
I was looking for another command our way of exporting data, but in this PL/SQL-programm (not via command line etc.) SO if I run the query via sqldeveloper (more a PL/SQL program) &nbsp;it does it al in once.<br />
<br />
Is there something existinng for this?<br />
Thanks,<br />

</div>


<div>
Some workarounds..<br />
<br />
1) Use UTL_FILE package<br />
2) Try making use of SPOOL (if possible)<br />
3) Write your own procedure which would split the string and print it. Check below link<br />
<br />
<a href="http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:146412348066" rel="ugc">http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:146412348066</a>
</div>


<div>
What about using a global temporary table? &nbsp;I believe you can write to those in a database that is open read only.<br />
<br />
Other than that I would say UTL_FILE is the best option.
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
I have a PSQL &nbsp;(not in a procedure) that uses dbms_output.put_line.But the output exeeds 1.000.000 chars (that is the maximum buffer size).<br />
So I need to change the way of output the results.<br />
I looked arround on the internet, but the solution to write to an other table is not possible (because I use a read-only database and I have no rights to change this).<br />
<br />
Can someone advise me here what I can do. <br />
(Small remark : I am not an expert in PL/SQl and ORACLE)<br />
<br />
Tkx,
</div>
</div>


Hi,
I have a PSQL  (not in a procedure) that uses dbms_output.put_line.But the output exeeds 1.000.000 chars (that is the maximum buffer size).
So I need to change the way of output the results.
I looked arround on the internet, but the solution to write to an other table is not possible (because I use a read-only database and I have no rights to change this).

Can someone advise me here what I can do. 
(Small remark : I am not an expert in PL/SQl and ORACLE)

Tkx,

SQL-Developer : PL/SQL dbms_output.put_line buffersize 1000000 exceeded - how to do it now?

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.