-
Expert Member
Error while creating a text file
While creating a text file using utl_file it is showing error message ora-29280: invalid directory path
I have set the path in init.ora in server as
utl_file_dir = 'd:\orahome\bin'
This is procedure code
create or replace procedure test_filehandling as
filehandle utl_file.file_type;
writemessage varchar2(200);
begin
filehandle := utl_file.fopen('\\10.15.1.197\d\orahome\bin','test.txt','w');
writemessage := 'this is created for testing purpose \n' || ' \n this is the second line';
utl_file.putf(filehandle,writemessage);
writemessage := ' line by line code using putline';
utl_file.put_line(filehandle,writemessage);
utl_file.fflush(filehandle);
utl_file.fclose(filehandle);
end;
/
could anyone suggest me what is wrong with the code?
Last edited by krishnaindia2007; 01-05-2008 at 03:05 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules