OraFAQ Forum: Windows » Problem with writing in directories (ORA-29283)

Home » Infrastructure » Windows » Problem with writing in directories (ORA-29283)

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

Problem with writing in directories (ORA-29283) [message #100796]

Tue, 07 October 2003 02:58

Rochut
Messages: 1
Registered: October 2003

Junior Member

Hi,
I've installed a database on my PC, and created an instance. I've also created a directory to read and write file with pl/sql procedure (I've created grant too). But when i try to execute a simple example like this :
exec
declare
test utl_file.file_type;
begin
test:=utl_file.fopen('export_dir','test.txt','w');
utl_file.put_line(test,'essai');
utl_file.fclose(test);
end;
/

I receive this error message :
ORA-29283: op�ration non valide sur le fichier
ORA-06512: � "SYS.UTL_FILE",
ligne 449
ORA-29283: op�ration non valide sur le fichier

If somebody has already encountered this problem...

Report message to a moderator

Re: Problem with writing in directories (ORA-29283) [message #100797 is a reply to message #100796]

Wed, 08 October 2003 06:45

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

are u using 9i?
did you create the directory as SYS and gave read/write permisssions on directory to user executing the proc?.
and
as per your posting
[i] 
test:=utl_file.fopen('export_dir','test.txt','w');
[/i]

if 'export_dir' is the directory u have created, the correct code should be

test:=utl_file.fopen('[b]EXPORT_DIR[/b]','test.txt','w');

EXPORT_DIR should be all caps

Report message to a moderator

Re: Problem with writing in directories (ORA-29283) [message #101120 is a reply to message #100796]

Tue, 11 May 2004 08:06

ramesh
Messages: 123
Registered: August 2000

Senior Member

Pls verify the directory,for the permission restriction.
PArameter utl_file_dir should have the value '*' in ur database

Report message to a moderator

Previous Topic:	OraOLEDB and Inner Join
Next Topic:	Home Number during installation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 13:46:49 CST 2024