ORU-10027: buffer overflow

[romain]

I use a cursor and I put cursor'content in file .doc


But : I receive this message : ORU-10027: buffer overflow, limit of 2000 bytes
I try to change serveroutput size but no success

Could you help me ?


Syntaxe :

set serveroutput on size 900000;
set line 150
spool c:\temp\liste_rejet.doc

DECLARE
CURSOR cur_com_cir IS
SELECT ...

c_com_cir cur_com_cir%ROWTYPE;

BEGIN



OPEN cur_com_cir;
LOOP

FETCH cur_com_cir INTO c_com_cir;
EXIT WHEN cur_com_cir%NOTFOUND;

dbms_output.put_line(c_com_cir.Fiche);

END LOOP;

CLOSE cur_com_cir;


END;
/
spool off

[gandolf989]

DBMS_OUTPUT.ENABLE(1000000);
The total amount sent to DBMS_OUTPUT should not exceed 1000000 bytes. I'm not sure what the maximum value for this is. You will need to add this after the begin section of the pl/sql block.