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