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
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
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
32kb is the max linesize if you specify it, othewise it is 1kb...
ASKER
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
Gio
ASKER
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
Gio