We were extracting some data into text file and then we noticed the above error. I checked many things, everything seemed ok. I realized that i get this error only for certain write operations when length of buffer was more than 1024. We had used following call to open file
UTL_FILE.fopen(<dir>, <filename>, 'w');
Since 4th parameter to UTL_FILE.fopen was not passed, it was defaulted to 1024. Hence the error when buffer was more than 1024.
Solution: we changed the call to UTL_FILE.fopen and passed 4th parameter max_linesize as 32767.
Tuesday, March 12, 2013
ORA-29285: file write error
Labels:
FND (Application Object Library)
Subscribe to:
Post Comments (Atom)
Its really help me..Thanks a lot.
ReplyDeleteRegards,
Amarnath
Wow, it does the magic, thx
ReplyDeletethanks..really help me solved my problem. Keep sharing!..:)
ReplyDeleteWorks Like a charm now.. wasted 2 days to understand what exactly the issue is..
ReplyDelete