dbms_output.put_line buffer limit [message #36487] |
Thu, 29 November 2001 10:57  |
Alex Ponce
Messages: 4 Registered: November 2001
|
Junior Member |
|
|
Is there a way to overcome the 1,000,000 byte limit when using dbms_output.put_line.
I need to run scritps that log to a text file the results and each table has millions of rows, so that limit is reached every time. I get the ORU-10027 buffer overflow error.
Any help will be greatly appreciated!
AP
----------------------------------------------------------------------
|
|
|
Re: dbms_output.put_line buffer limit [message #36489 is a reply to message #36487] |
Thu, 29 November 2001 12:52  |
hello
Messages: 17 Registered: November 2001
|
Junior Member |
|
|
It's not possible with dbms_output.put_line. but if possible u can use fnd_file.put_line
this does not have buffer limit
----------------------------------------------------------------------
|
|
|