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