OraFAQ Forum: Server Administration » utl_file error

Home » RDBMS Server » Server Administration » utl_file error

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

utl_file error [message #370608]

Wed, 05 January 2000 18:02

scott campbell
Messages: 13
Registered: July 1999

Junior Member

I'm using utl_file to read a datafile into an oracle table. At the ~150th record, I receive the following error:

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

I'm not sure if it's a result of a session parameter, a database parameter or a limitation of utl_file under Oracle V7.3.4. Any help is appreciated. Thanks in advance.

Report message to a moderator

Re: utl_file error [message #370619 is a reply to message #370608]

Mon, 10 January 2000 12:42

scott campbell
Messages: 13
Registered: July 1999

Junior Member

fyi --- it turned out to be a session parameter that was limiting the number of screen writes that i could perform.

Report message to a moderator

Re: utl_file error [message #372497 is a reply to message #370608]

Thu, 15 February 2001 12:30

Pramote
Messages: 1
Registered: February 2001

Junior Member

Modify buffer size in SQL*PLUS by using the
following command:
SET SERVEROUTPUT ON SIZE n
where n is an integer between 2000 and 1000000

Report message to a moderator

Previous Topic:	Re: dispaly the COLUMNS and data on Tablar style - URL
Next Topic:	Re: dispaly the COLUMNS and data on Tablar style.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 01:11:59 CST 2024