Set DBMS_OUTPUT buffer
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Set DBMS_OUTPUT buffer

  1. #1
    Join Date
    Mar 2001
    Posts
    109
    I am currently using dbms_output.put_line to debug a pl/sql procedure and got an error "buffer overflow, limit of 2000 bytes".

    Could any one tell me how to reset this DBMS_OUTPUT buffer size?

    Thanks in advance.
    zm

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    The default and minimum size is 2000. Maximum is 1,000,000. When you set serveroutput on, dbms_output.enable is implicitly called, with the default size of 2000.

    SET SERVEROUTPUT ON SIZE n
    where n is an integer between 2,000 and 1,000,000.

Posting Permissions

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


Click Here to Expand Forum to Full Width