-
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
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|