Home » SQL & PL/SQL » SQL & PL/SQL » Changing maximum size of buffer in the Put_Line procedure of the UTL_File package
Changing maximum size of buffer in the Put_Line procedure of the UTL_File package [message #365798] Fri, 04 February 2000 12:29 Go to next message
Mohit Agarwal
Messages: 2
Registered: February 2000
Junior Member
Is it possible to use the Put_Line procedure in the UTL_File package to write a line greater than 1023 bytes in size?

Mohit
Re: Changing maximum size of buffer in the Put_Line procedure of the UTL_File package [message #365906 is a reply to message #365798] Tue, 14 March 2000 12:08 Go to previous messageGo to next message
fundu
Messages: 2
Registered: March 2000
Junior Member
hey mohit..am having a similar prob.. pls email me if u have found a soln.
fundu
Re: Changing maximum size of buffer in the Put_Line procedure of the UTL_File package [message #365907 is a reply to message #365798] Tue, 14 March 2000 12:31 Go to previous message
Mohit Agarwal
Messages: 2
Registered: February 2000
Junior Member
If you have version 8.0.5 or higher there is a fix. A new parameter was added to the UTL_FILE.FOPEN function to change the default size of 1K for the line buffer. Its the fourth parameter and can have a max value of 8K.
There is no fix if you have an earlier version. You could however run the query in SQL*Plus and use SPOOL to write the results into a text file.
Mohit
Previous Topic: URGENT!calculation of difference of time.
Next Topic: HELP-STUPID QUESTION
Goto Forum:
  


Current Time: Mon Jun 21 21:46:55 CDT 2021