OraFAQ Forum: SQL & PL/SQL » UTL_FILE - buffer overflow, limit of 2000 bytes

Home » SQL & PL/SQL » SQL & PL/SQL » UTL_FILE - buffer overflow, limit of 2000 bytes (DB 8.1.7, Solaris)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

UTL_FILE - buffer overflow, limit of 2000 bytes [message #338134]

Sun, 03 August 2008 23:15

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.

Report message to a moderator

Re: UTL_FILE - buffer overflow, limit of 2000 bytes [message #338136 is a reply to message #338134]

Sun, 03 August 2008 23:24

BlackSwan
Messages: 26766
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

flyboy
Messages: 1903
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

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

Report message to a moderator

Re: UTL_FILE - buffer overflow, limit of 2000 bytes [message #343578 is a reply to message #343254]

Wed, 27 August 2008 10:11

Barbara Boehmer
Messages: 9100
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

Report message to a moderator

Previous Topic:	help whit RECORD.
Next Topic:	datadictionary / system-view for records

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 12 05:00:14 CST 2024