13 Replies Latest reply: Jan 6, 2009 8:04 AM by BluShadow RSS

    ORA-29280: invalid directory path

    Amasoni
      Hi all!
      I'm getting this error when i run

      declare
      f utl_file.file_type;
      s varchar2(200);
      begin
      f := utl_file.fopen('c:\Amasoni\lib','Libook2.txt','R');
      utl_file.get_line(f,s);
      utl_file.fclose(f);
      dbms_output.put_line(s);
      end;
      /


      and yet i have the path as can b seen below

      SQL> select * from all_directories;



      OWNER DIRECTORY_NAME
      ------------------------------ ------------------------------
      DIRECTORY_PATH
      --------------------------------------------------------------------------------
      SYS LIB
      c:\amasoni\lib

      Wat cld the problem b?

      Thnx