Home » SQL & PL/SQL » SQL & PL/SQL » UTL_FILE - buffer overflow, limit of 2000 bytes (DB 8.1.7, Solaris)
UTL_FILE - buffer overflow, limit of 2000 bytes [message #338134] Sun, 03 August 2008 23:15 Go to next message
ying
Messages: 143
Registered: May 2002
Senior Member
Hi,

Reading a File using utl_FILE [message #41027]

I'm trying using the utl_FILE test_file package which was posted in above forum.

After executing the procedure I get the error message as below:
ERROR at line 1:
ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes
ORA-06512: at "APPS.TEST_FILE", line 75
ORA-06512: at line 1

I have no idea which part of the program cause the problem. I have tried to increase the size of the variable, but still same problem.

Pls advise.
Re: UTL_FILE - buffer overflow, limit of 2000 bytes [message #338136 is a reply to message #338134] Sun, 03 August 2008 23:24 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guideline as stated in URL above



You have tables.
You have data.
You have application code.
You have error code.
You have problem you can not solve.

We have error code.
We have have problem we can not solve.

you loose!

[Updated on: Sun, 03 August 2008 23:24] by Moderator

Report message to a moderator

Re: UTL_FILE - buffer overflow, limit of 2000 bytes [message #338139 is a reply to message #338134] Sun, 03 August 2008 23:43 Go to previous messageGo to next message
flyboy
Messages: 1832
Registered: November 2006
Senior Member
> I'm trying using the utl_FILE test_file package which was posted in above forum.
Sorry, I have not found it on the first page of "SQL & PL/SQL" forum and I am too lazy to make any other effort. Why do you not post it here or (better) continue in that thread?

> ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes
Are you using DBMS_OUTPUT in the code? If so, just set the SIZE parameter of SET SERVEROUTPUT command to appropriate (bigger) value.

[Updated on: Sun, 03 August 2008 23:43]

Report message to a moderator

Re: UTL_FILE - buffer overflow, limit of 2000 bytes [message #343254 is a reply to message #338134] Tue, 26 August 2008 15:16 Go to previous messageGo to next message
apharnashri
Messages: 2
Registered: June 2008
Junior Member
Hi,
I guess u have too many dbms_output.put_line statements in your procedure due to which it is causing this error.
Try removing those and test it.
thanks,
Apharna
Re: UTL_FILE - buffer overflow, limit of 2000 bytes [message #343578 is a reply to message #343254] Wed, 27 August 2008 10:11 Go to previous message
Barbara Boehmer
Messages: 8636
Registered: November 2002
Location: California, USA
Senior Member
The following link contains a my_dbms_output package by Tom Kyte that is a workaround for the dbms_output limitation in older versions.


http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:146412348066
Previous Topic: help whit RECORD.
Next Topic: datadictionary / system-view for records
Goto Forum:
  


Current Time: Sat Dec 10 10:35:58 CST 2016

Total time taken to generate the page: 0.26670 seconds