This discussion is archived
13 Replies Latest reply: Jan 6, 2009 6:04 AM by BluShadow RSS

ORA-29280: invalid directory path

Amasoni Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points