Hi,
I have executed the below step from 'APPS' schema...
CREATE OR REPLACE DIRECTORY EE_TRANS_OTL_DIR AS '/tmp/otl';
when I query ALL_DIRECTORIES..I got to know that Owner is showing 'SYS' though I ran the create command from 'APPS'..
SELECT * from all_directories WHERE directory_name='EE_TRANS_OTL_DIR'
Result:
=======
| OWNER | DIRECTORY_NAME | DIRECTORY_PATH |
| SYS | EE_TRANS_OTL_DIR | /tmp/otl |
Now I am trying to run below query from APPS Schema...
Declare
CURSOR c_get_data IS
SELECT employee_number, employee_name
FROM ee_trans_emp_attendance_report
WHERE rownum <= 4;
output_file utl_file.file_type;
v_wstring varchar2 (100);
v_header varchar2(100);
v_file varchar2(100);
v_date varchar2(20);
BEGIN
v_header :='empno'||chr(9)||'ename';
v_file := 'Test.xls';
ee_trans_common_pkg.print('L','Y','header '||v_header);
output_file := utl_file.fopen ('EE_TRANS_OTL_DIR',v_file, 'W');
utl_file.put_line(output_file,v_header);
for rec_get_data in c_get_data loop
v_wstring := rec_get_data.employee_number||chr(9)||rec_get_data.employee_name;
ee_trans_common_pkg.print('L','Y',v_wstring);
utl_file.put_line(output_file,v_wstring);
end loop;
utl_file.fclose (output_file);
EXCEPTION WHEN OTHERS THEN
ee_trans_common_pkg.print('L','Y',SQLERRM);
END;
I am getting below error:
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation
Is there any privilege problem..?