Wednesday, September 26, 2012

ORA-29285: File Write Error

I got this error when I tried to write more than 1024 characters on a line.
Before:

   fileXrxHandle   := UTL_FILE.FOPEN('LOG', lv_xrx_file_name, 'W');
Here I've opened a file without specifying the maximum number of characters on a line.

After:
   fileXrxHandle   := UTL_FILE.FOPEN('LOG', lv_xrx_file_name, 'W',32767);
Here I've opened a file specifying  the maximum number of characters on a line.The max value that oracle accepts is 32767.

This change resolved  ORA-29285: File Write Error.

No comments:

Post a Comment