?
Solved

UTL_FILE.WRITE_ERROR

Posted on 2004-09-07
5
Medium Priority
?
1,378 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 23

Assisted Solution

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

Accepted Solution

by:
bvanderveen earned 800 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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses

762 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