ORA-29285: file write error [message #120878] |
Tue, 24 May 2005 07:58 |
Srini1234
Messages: 4 Registered: May 2005 Location: Mumbai
|
Junior Member |
|
|
Hi,
I am trying to write output of a procedure to a file(XML file).
I tested it in Oracle8i it is working fine..But in 9i it is giving error "ORA-29285: file write error"
--xmlString is the Long which has data to be write.
fileHandler := UTL_FILE.FOPEN ('F:\XML_RTU', 'TEST123.XML', 'w');
UTL_FILE.PUTF(fileHandler, xmlString);
UTL_FILE.FCLOSE(fileHandler);
please can any one suggest me alternate solution..
Thanks in anticipation
Srini
|
|
|
Re: ORA-29285: file write error [message #120892 is a reply to message #120878] |
Tue, 24 May 2005 09:14 |
smartin
Messages: 1803 Registered: March 2005 Location: Jacksonville, Florida
|
Senior Member |
|
|
First thing to check on all errors with writing and reading files (in any language, any platform) is to make sure the process/program doing the writing has read/write access to the drive/path in question.
Also you can/should use directory objects rather than straight file names for IO operations. If you don't, you'll need to check your utl_file parameter.
|
|
|
Re: ORA-29285: file write error [message #120907 is a reply to message #120892] |
Tue, 24 May 2005 10:44 |
Srini1234
Messages: 4 Registered: May 2005 Location: Mumbai
|
Junior Member |
|
|
Hi smart,
I found it problem with 9i for UTL_FILE.FCLOSE.
I did a small change in the code..it started working..i added one more parameter in UTL_FILE.FOPEN ().
Any how thanks for advice..
fileHandler := UTL_FILE.FOPEN ('F:\XML_RTU', 'TEST123.XML', 'w',32767);
UTL_FILE.PUTF(fileHandler, xmlString);
UTL_FILE.FCLOSE(fileHandler);
|
|
|
|