1

Topic: UTL_FILE: Invalid file operation

Kind meal, All!
Oracle 11.2.0.4 / Win64
There is such construction:

create or replace PROCEDURE EXPFILES
AS
CURSOR C1 IS
SELECT FILENAME FROM FILESTABLE WHERE FILE_ID=61;
v_filename utl_file.file_type;
currentfile VARCHAR2 (255);
BEGIN
OPEN C1;
FETCH C1 into currentfile;
v_filename: = utl_file.fopen (' FILEEXPORT ', currentfile, ' w ');
utl_file.put_line (v_filename, ' test ');
UTL_FILE.fflush (v_filename);
UTL_FILE.fclose (v_filename);
CLOSE C1;
END EXPFILES;

The directory is created. Procedure is launched from the user with rights DBA. Grants , it is right is. We receive:
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation
If I write hands

v_filename: = utl_file.fopen (' FILEEXPORT ', ' testfile.txt, ' w ');

The file forms as it is necessary. And even if the file name Russian letters too forms as is necessary. Who has reasons about it?

2

Re: UTL_FILE: Invalid file operation

t0rik wrote:

Procedure is launched from the user with rights DBA.

RTFM the TOP No4

3

Re: UTL_FILE: Invalid file operation

t0rik wrote:

reasons

long thought... Ah yes! To pay attention to value currentfile.

4

Re: UTL_FILE: Invalid file operation

In -4 did not find the answer to the question.

5

Re: UTL_FILE: Invalid file operation

dump (null) wrote:

it is passed...
Long thought... Ah yes! To pay attention to value currentfile.

And what with it not so?