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!

AP

----------------------------------------------------------------------
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
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

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


Current Time: Tue Apr 16 10:35:52 CDT 2024