Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2003
    Location
    Paris
    Posts
    38

    Unanswered: Buffer size in sqlplus

    I've had this error

    ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes
    ORA-06512: "SYS.DBMS_OUTPUT", ligne 91
    ORA-06512: "SYS.DBMS_OUTPUT", ligne 58
    ORA-06512: "TRESIMMO.NREG", ligne 113

    I'd like to change the buffer size.

    Can anyone help me?
    Cordialement

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Buffer size in sqlplus

    Originally posted by Crassus
    I've had this error

    ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes
    ORA-06512: "SYS.DBMS_OUTPUT", ligne 91
    ORA-06512: "SYS.DBMS_OUTPUT", ligne 58
    ORA-06512: "TRESIMMO.NREG", ligne 113

    I'd like to change the buffer size.

    Can anyone help me?
    SET SERVEROUPUT ON SIZE 1000000

  3. #3
    Join Date
    Feb 2003
    Location
    Paris
    Posts
    38
    Thanks, Tony.

    I didn't know that one.

    Is there, however, a way to permanently increase the buffer size parameter?
    Cordialement

  4. #4
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    Originally posted by Crassus
    Thanks, Tony.

    I didn't know that one.

    Is there, however, a way to permanently increase the buffer size parameter?
    You can put that command in your login.sql or glogin.sql script so that it runs every time you start SQL Plus.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •