Results 1 to 6 of 6

Thread: File input/output in Pl/Sql

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Expert Member
    Join Date
    Sep 2007
    Answers
    697

    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
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact