utl_file_dir in oracle 10g - gives invalid path error..
Posted on 2007-07-19
I have a sample procedure which when executed gives
CREATE OR REPLACE PROCEDURE EmployeeFlatFile
file_id := utl_file.FOPEN( '/apps/myuser/output', 'test.txt', 'w' );
FOR emp IN (SELECT employee_name FROM employee)
utl_file.PUT_LINE( file_id, emp.employee_name );
ORA-29280: invalid directory path
ORA-06512: at "SYS.UTL_FILE", line 33
ORA-06512: at "SYS.UTL_FILE", line 436
ORA-06512: at "myschema.employeeflatfile", line 5
ORA-06512: at line 2
dba's assured that they have the entry /apps/myuser/output in the utl_file_dir (init.ora) and the same setting works in oracle 8i - how do I rectify this problem,.. any suggestions are welcome!!!