Re: SET SERVEROUTPUT ON SIZE - only 1000000 bytes?

Miguel Nunes Pinto wrote:
>
> Hy,
>
> I need to spool de result of a query into a file.
> I'm using, in a PL/SQL block, a cursor for the query and a
> dbms_output.put_line to send the results to the file.
> In the beginning i just set this:
>
> set serveroutput on;
>
> Then the first error was this:
>
> begin
> *
> ERROR at line 1:
> ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes
> ORA-06512: at line 43
>

Use utl_file instead - it does not have that limitation. Received on Tue Feb 15 2000 - 00:00:00 CST