UTL_FILE exception: INVALID OPERATION

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 Mon Sep 20 2004 - 09:38:51 CDT