Home » SQL & PL/SQL » SQL & PL/SQL » dbms_output.put_line buffer limit
dbms_output.put_line buffer limit [message #36487] Thu, 29 November 2001 10:57 Go to next message
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!


Re: dbms_output.put_line buffer limit [message #36489 is a reply to message #36487] Thu, 29 November 2001 12:52 Go to previous message
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

Previous Topic: Comparing two dates
Next Topic: Database System Triggers - Urgent
Goto Forum:

Current Time: Fri May 24 09:02:52 CDT 2024