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

Question: 
I am using a procedure to try to pull data for reporting purposes.  I am getting the following ORA-20000 with ORU-10027 error:

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

I need the output for a report, so I cannot just disable it to eliminate the ORA-20000 ORU-10027.

What can I do to get rid of the ORA-20000 ORU-10027 error?

Answer: 
DBMS_OUTPUT has different default buffer sizes, depending on your Oracle version.  For your system, the limit is 2000 bytes.You can increase the buffer up to 1,000,000 using the following PL/SQL statement:

 DBMS_OUTPUT.ENABLE(1000000);

The SQL*Plus statement to achieve the same result is:

set serveroutput on size 1000000

Starting with Oracle release 10g, it is possible to use the following unlimited buffer settings:

• PL/SQL: DBMS_OUTPUT.ENABLE (buffer_size => NULL);
• SQL*Plus: set serveroutput on size unlimited

Since I do not have the code you are running, I cannot do a full diagnostic on it.  If the DBMS_OUTPUT settings in the code are acceptable for your version of Oracle and the client (SQL*Plus, etc.) you are using and you are still getting the ORA-20000 ORU-10027 buffer overflow error for the stated limits, you should check your full code to determine whether there are any other calls that include conflicting DBMS_OUTPUT.ENABLE settings that might be overriding yours.

[Solved]Error No: 53 File not found Bi Publisher

Issue:
Following error pop-up is coming when we hit Oracle BI Publisher > Preview > PDF/EXCEL 
Error No: 53
Desc: File not found
Please confirm that
1) Java runtime version is 1.3 or later is installed correctly
2) The Java executable is accessible through the Windows Path or the Java Home directory is entered in the Preview tab of the options dialog

Solution:
Select correct Java Home by clicking on Browser button next to it.

Navigation:
 Ms Word -->Tools -- > options --> preview tab.

Java home should be selected there, if not select it or update path