Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1427
  • Last Modified:

UTL_FILE.WRITE_ERROR

I've been receiving this error, but looking up in documentation it says that this is an O/S error and that's it.

I'm just PUTting and PUT_LINE-ing data to a file.  I get through about 22 iterations of a cursor for loop and then the exception is raised but I have no clue.

Is there a buffer limitation as to how much you can write out to a straight line (i.e. using PUT continously on one line then finally doing a PUT_LINE)?

Thanks,
Gio
0
jaramill
Asked:
jaramill
  • 2
  • 2
2 Solutions
 
seazodiacCommented:
yes, in Oracle9i, 32Kbytes..
0
 
bvanderveenCommented:
You might try UTL_FILE.FFLUSH to clear the buffer.

I'm not aware of any limitation on how long a single line can be.

There is an error (in 8.0.5 + versions) called INVALID_MAXLINESIZE that would be thrown if you had a line too large.

There is an overloaded version of FOPEN that has a max_linesize parameter, and it is a binary_integer type, having a max value of 32767.  If not specified, the max_linesize is 1024.

Signature of FOPEN:
   UTL_FILE.FOPEN(location IN VARCHAR2,
                            filename in VARCHAR2,
                            open_mode in VARCHAR2,
                            max_linesize in BINARY_INTEGER)

Try it with a larger version of max_linesize, and see what happens.
0
 
bvanderveenCommented:
32kb is the max linesize if you specify it, othewise it is 1kb...
0
 
jaramillAuthor Commented:
Thanks.  I'm on Oracle8i (8.1.6.2.0) and I see that the limit is only 1kb as mentioned so I'll try to set it to that and get back to you.

Gio
0
 
jaramillAuthor Commented:
Sometimes reading the manual a "little" more clearly would've dug this info up for me but sometimes you need another pair of eyes.  That was it guys.  Thanks for the help bvanderveen.

Gio
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now