Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQL_PLUS buffer overflow

SQL_PLUS buffer overflow

From: s Lehaire <s.lehaire_at_meilleuregestion.com>
Date: Fri, 7 Jun 2002 16:13:16 +0200
Message-ID: <adqe5n$3fp$1@reader1.imaginet.fr>


 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 Received on Fri Jun 07 2002 - 09:13:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US