Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-29283: invalid file operation;ORA-06512: at "SYS.UTL_FILE", line 536

Ramesh9158Feb 24 2014 — edited Feb 24 2014

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:

=======

OWNERDIRECTORY_NAMEDIRECTORY_PATH
SYSEE_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..?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 24 2014
Added on Feb 24 2014
18 comments
16,472 views