Re: SQL_PLUS buffer overflow

From: Oraclion <oracle_at_epicentre.fr>
Date: Fri, 7 Jun 2002 17:15:36 +0200
Message-ID: <adqija$ikp$1@wanadoo.fr>

try with
dbms_output.enable(500000);

before call your procedure or function

Denis JEANNERET

---

---

Très cordialement
Denis Jeanneret - Directeur Technique, Division ORACLE Epicentre - 529 Route des Vernes 74370 PRINGY Tel: 04.5009.7000
Fax:04.50.66.92.19

"s Lehaire" <s.lehaire_at_meilleuregestion.com> wrote in message news:adqdg7$39p$1_at_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 - 10:15:36 CDT