Home » Infrastructure » Windows » Problem with writing in directories (ORA-29283)
Problem with writing in directories (ORA-29283) [message #100796] Tue, 07 October 2003 02:58 Go to next message
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...
Re: Problem with writing in directories (ORA-29283) [message #100797 is a reply to message #100796] Wed, 08 October 2003 06:45 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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

Re: Problem with writing in directories (ORA-29283) [message #101120 is a reply to message #100796] Tue, 11 May 2004 08:06 Go to previous message
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
Previous Topic: OraOLEDB and Inner Join
Next Topic: Home Number during installation
Goto Forum:
  


Current Time: Fri Mar 29 05:51:09 CDT 2024