Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    84

    Unanswered: ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes

    Hi,

    Encountering following errors while executing procedure MIS_AR_INVOICE_P

    error: ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes
    procedure: MIS_AR_INVOICE_P

    Databse Version is 9i and Some Oracle apps objects are also accessed via db link.
    Any suggestions

  2. #2
    Join Date
    Jan 2004
    Posts
    1

    Wink

    This error shows that the data is going missing from your DBMS_OUTPUT and you are using direct calls to DBMS_OUTPUT.PUT_LINE in your procedures, then you must be ignoring errors somewhere and this could be indicative of more than just the missing debug messages problem. Best check through all your exception handling code and remove any calls to 'when others then null;' unless you are absolutely sure that it is appropriate.

    There is another function call in the DBMS_OUTPUT package called GET_LINE (or GET_LINES to get more than one) which removes data from the buffer. Unfortunately, removing data from the buffer does not free up the space to allow more to be added, the one million byte limit still applies.

    DBMS_OUTPUT is therefore only useful for very small amounts of debugging information, or script/procedure output. If you need more, you are advised to use UTL_FILE which has no output size limit and since 8i, is able to have user defined line lengths.
    You can also try increasing the buffer value and retry the operation.
    Use the sql :
    SQL> execute dbms_output.enable(1000000);

  3. #3
    Join Date
    Jan 2004
    Posts
    84
    Thank You!
    It was resolved with SET SERVEROUTPUT ON SIZE 1000000 .

Posting Permissions

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