Hi, In my procedure I am trying to read a table and write the content to a text file and store it in a directory. But I am getting this error.
ORA-29283: invalid file operation ORA-06512: at "SYS.UTL_FILE", line 475 ORA-29283: invalid file operation ORA-06512: at line 14 create or replace PACKAGE BODY pkg_test AS DUMP_DIR CONSTANT VARCHAR2(30) := 'TEST_TEMP'; PROCEDURE dump_test(Filename IN VARCHAR2) IS c sys_refcursor; fout utl_file.file_type; BEGIN ------ ----- ---- fout := utl_file.fopen(DUMP_DIR, Filename, 'w', 32767); --- ---- END dump_test; END pkg_test; I have created this directory using the following command. CREATE OR REPLACE DIRECTORY test_temp AS '/home/Sam/test_temp' output --------- CREATE OR REPLACE DIRECTORY succeeded. on my file system I created test_temp (/home/Sam/)and gave read,write and execute Privileges. In sql Developer I can see the directory created. But I am not sure what is going wrong. Please help. Thanks, Sam --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
