OraFAQ Forum: SQL & PL/SQL » invalid file operation

Home » SQL & PL/SQL » SQL & PL/SQL » invalid file operation (Oracle 12C , IBM AIX)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

invalid file operation [message #662678]

Tue, 09 May 2017 09:03

Durai_1
Messages: 2
Registered: May 2017

Junior Member

I am getting the below error while trying to create a file in unix box using sqlplus. Can anyone have idea how to resolve this?

SQL>declare
v_buff VARCHAR2(2000);
fhandle UTL_FILE.FILE_TYPE;
begin
dbms_output.put_line('WRITE');
fhandle:= UTL_FILE.FOPEN('HHT_DIR','Report.txt','W');
UTL_FILE.put_line(fhandle,' Attempt to write');
UTL_FILE.FCLOSE(fhandle);
end;
/
2 3 4 5 6 7 8 9 10 declare
*
ERROR at line 1:
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation
ORA-06512: at line 6

Report message to a moderator

Re: invalid file operation [message #662680 is a reply to message #662678]

Tue, 09 May 2017 09:19

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

It works OK for me.

  1  declare
  2  v_buff VARCHAR2(2000);
  3  fhandle UTL_FILE.FILE_TYPE;
  4  begin
  5  dbms_output.put_line('WRITE');
  6  fhandle:= UTL_FILE.FOPEN('LOG_FILE_DIR','Report.txt','W');
  7  UTL_FILE.put_line(fhandle,' Attempt to write');
  8  UTL_FILE.FCLOSE(fhandle);
  9* end;
SQL> /

PL/SQL procedure successfully completed.

Report message to a moderator

Re: invalid file operation [message #662681 is a reply to message #662680]

Tue, 09 May 2017 09:32

Durai_1
Messages: 2
Registered: May 2017

Junior Member

Hi,

But in my machine I am getting this particular error. I want to know why it is throwing this error

-Durai

Report message to a moderator

Re: invalid file operation [message #662682 is a reply to message #662681]

Tue, 09 May 2017 09:44

Solomon Yakobson
Messages: 3312
Registered: January 2010
Location: Connecticut, USA

Senior Member

Is "my machine" database server or database resides on a different server?

SY.

Report message to a moderator

Re: invalid file operation [message #662690 is a reply to message #662678]

Tue, 09 May 2017 10:38

EdStevens
Messages: 1377
Registered: September 2013

Senior Member

What does this query reveal:

select * from dba_directories where directory_name='HHT_DIR';

And does the OS directory shown by DIRECTORY_PATH actually exist?

It is a common misconception that creating a directory object in the db also creates the OS directory on disk. It doesn't.

Report message to a moderator

Re: invalid file operation [message #662692 is a reply to message #662681]

Tue, 09 May 2017 11:08

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Durai_1 wrote on Tue, 09 May 2017 07:32

Hi,

But in my machine I am getting this particular error. I want to know why it is throwing this error

-Durai

error is thrown because the FOPEN fails.

If you can't debug posted code, then consider you might not have the capacity to be a PL/SQL programmer.

Report message to a moderator

Previous Topic:	Produce output not having any or all inputs (products)
Next Topic:	Decode and To_date

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Aug 03 21:21:39 CDT 2026