Solved

UTL_FILE.WRITE_ERROR

Posted on 2004-09-07
5
1,306 Views
Last Modified: 2012-06-21
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
Comment
Question by:jaramill
  • 2
  • 2
5 Comments
 
LVL 23

Assisted Solution

by:seazodiac
seazodiac earned 25 total points
ID: 12000087
yes, in Oracle9i, 32Kbytes..
0
 
LVL 7

Accepted Solution

by:
bvanderveen earned 200 total points
ID: 12000107
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
 
LVL 7

Expert Comment

by:bvanderveen
ID: 12000114
32kb is the max linesize if you specify it, othewise it is 1kb...
0
 
LVL 3

Author Comment

by:jaramill
ID: 12000123
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
 
LVL 3

Author Comment

by:jaramill
ID: 12000165
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now