SQL & PL/SQL

Hey all,

I am trying to execute a procedure that initially reads a file from the server using UTL_FILE utility and am getting the following error:

I am in OTHERS exception block:::ORA-29283: invalid file operation
ORA-06512: at
"SYS.UTL_FILE", line 475
ORA-29283: invalid file operation

What's weird is the permissions are appropriate, the file name, directory path and everything else is fine, still the invalid file operation error is being thrown out. Even weirder is the fact that I just had someone on DBA team execute the procedure and it worked fine for him. The file has full permissions(rwxrwxrwx) as well the directory in which it resides.

The following is the piece of code where the file is being opened:

stmt_string := 'create or replace directory '||batch_name||' as '''||dir||'''';
EXECUTE IMMEDIATE stmt_string;
dbms_output.put_line('Dir Created...');


l_output := utl_file.fopen(batch_name,file_name,'r',32767);
dbms_output.put_line('************ File opened succesfully *******************');

Any ideas on why the error is being thrown out?