ORA-29280: invalid directory path
AmasoniJan 6 2009 — edited Jan 6 2009Hi 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