Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: UTL_FILE exception: INVALID OPERATION
Try after changing the 3rd paramater (open_mode) from uppercase 'W' to
lowercase 'w'. Same goes for 'r' (Read) and 'a' (Append).
Regards
/Rauf
sbi_at_bio.ri.ccf.org (Sharon) wrote in message news:<f2ea69f1.0409200638.78654d80_at_posting.google.com>...
> I am trying to executing a procedure having some codes like this
>
> data_file_handle := utl_file.fopen('C:\temp','123.dat', 'W');
>
> utl_file.fclose(data_file_handle);
>
> exception
>
> when utl_file.invalid_path then
> p_status := 'UTL_FILE exception: INVALID PATH';
> when utl_file.invalid_mode then
> p_status := 'UTL_FILE exception: INVALID MODE';
> when utl_file.invalid_filehandle then
> p_status := 'UTL_FILE exception: INVALID FILEHANDLE';
> when utl_file.read_error then
> p_status := 'UTL_FILE exception: READ ERROR';
> when utl_file.write_error then
> p_status := 'UTL_FILE exception: WRITE ERROR';
> when utl_file.internal_error then
> p_status := 'UTL_FILE exception: INTERNAL ERROR';
> when utl_file.invalid_operation then
> p_status := 'UTL_FILE exception: INVALID OPERATION';
>
> I first set utl_file_dir = C:\temp in my init.ora file
>
> When I ran it, I got 'UTL_FILE exception: INVALID OPERATION'
>
> Doesn't anyone has any clue what could be the reason to cause this?
>
> Thanks in advance!
Received on Tue Sep 21 2004 - 06:52:45 CDT