ORACLE 9i REL 2 - UTL_FILE_DIR
I AM TRYING TO CREATE A TEXT FILE AS FOLLOWS
AS SYSTEM..
Create or Replace procedure UTLTEST as
f1 utl_file.file_type;
begin
-- Open a file in write mode
f1 := utl_file.fopen('MYFILE','NEWFILE.TXT','W');
-- Write a line to a file
utl_file.put_line(f1,'1. This is a test of UTL_FILE packages');
utl_file.put_line(f1,'2. Oracle has added a new procedures in the package');
utl_file.put_line(f1,'3. We will see all the procedure one by one');
-- Close a file
utl_file.fclose(f1);
exception
WHEN UTL_FILE.INVALID_PATH THEN
DBMS_OUTPUT.PUT_LINE ('invalid_path'); RAISE;
WHEN UTL_FILE.INVALID_MODE THEN
DBMS_OUTPUT.PUT_LINE ('invalid_mode'); RAISE;
WHEN UTL_FILE.INVALID_FILEHANDLE THEN
DBMS_OUTPUT.PUT_LINE ('invalid_filehandle'); RAISE;
WHEN UTL_FILE.INVALID_OPERATION THEN
DBMS_OUTPUT.PUT_LINE ('invalid_operation'); RAISE;
WHEN UTL_FILE.READ_ERROR THEN
DBMS_OUTPUT.PUT_LINE ('read_error'); RAISE;
WHEN UTL_FILE.WRITE_ERROR THEN
DBMS_OUTPUT.PUT_LINE ('write_error'); RAISE;
WHEN UTL_FILE.INTERNAL_ERROR THEN
DBMS_OUTPUT.PUT_LINE ('internal_error'); RAISE;
end;
DIR CREATED AS
CREATE OR REPLACE DIRECTORY MYFILE AS 'C:\APPS\ORDER1';
GRANT READ ON DIRECTORY MYFILE TO ADMIN1;
WHEN I EXECUTE THIS FILE AS ADMIN1
EXEC SYSTEM.utltest
HERE IS THE ERROR MESSAGE
SQL> EXEC SYSTEM.utltest
invalid_operation
BEGIN SYSTEM.utltest; END;
*
ERROR at line 1:
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 449
ORA-29283: invalid file operation
ORA-06512: at "SYSTEM.UTLTEST", line 33
ORA-06512: at line 1
COULD SOME ONE PLEASE HELP ?