| 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.
|
|
|
|
|
|
| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
