ORA-200000

From: FLAVIEN COSMES <flavien.cosmes1_at_worldonline.fr>
Date: 28 Nov 2002 02:14:58 -0800
Message-ID: <76ebfc2f.0211280214.25df735c@posting.google.com>

Hi !
I've got this message (in french because I'm french) in SQL_PLUS when there is to much DBMS_OUTPUT.PUT_LINE()
So can I increase the buffer of sql_plus? I've to see a debug of my procedure.

ERREUR à la ligne 1 :

 ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes
 ORA-06512: à "SYS.DBMS_OUTPUT", ligne 34
 ORA-06512: à "SYS.DBMS_OUTPUT", ligne 118
 ORA-06512: à "SYS.DBMS_OUTPUT", ligne 81
 ORA-06512: à "MPDEV.PR_MY_PROCEDURE", ligne 20
 ORA-06512: à ligne 1

Thx for response

the right answer is set serveroutput on size 10000000 (what ever you want) Received on Thu Nov 28 2002 - 04:14:58 CST