| Error in using UTL_FILE package [message #369834] |
Thu, 19 October 2000 09:29  |
guruprasad
Messages: 6
Registered: October 2000
|
Junior Member |
|
|
Hi,
I am trying to use UTL_FILE package to do file processing. I am reading from several tables and forming a record and then I am trying to write it to a file. But, I am getting the below error
ERROR at line 1:
ORA-20010: ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes
ORA-06512: at "CISDBA.SUPPLIER_PACKAGE", line 92
ORA-06512: at line 1
I am using UTL_FILE.fopen(direc, file,'w',32767) to open the file and then using UTL_FILE.put_line(out_file, output) to write its contents. 'output' is the buffer length of size Varchar2(32767) which is maximum length and 'out_file' is the file handle. I couldn't get any help from the Oracle documentation.
An earliest help would be greatly appreciated.
Thanks,
Guru
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
