| UTL_FILE : Getting ORA-29283: invalid file operation error after performing all pre-requisties [message #579459] |
Tue, 12 March 2013 06:48  |
 |
Lazydba
Messages: 6
Registered: March 2013
|
Junior Member |
|
|
I have writtenonce UTL_FILE code but getting "ORA-29283: invalid file operation" error. Please suggest.
Performed below steps while writting code,
CONNECT / AS SYSDBA
CREATE OR REPLACE DIRECTORY DIR_EXTRACT AS 'P:\tmp';
GRANT READ, WRITE ON DIRECTORY DIR_EXTRACT TO User1;
GRANT EXECUTE ON UTL_FILE TO User1;
Connect User1/User1
DECLARE
fHandler UTL_FILE.FILE_TYPE;
BEGIN
fHandler := UTL_FILE.FOPEN('DIR_EXTRACT', 'myfile.txt', 'w');
UTL_FILE.PUTF(fHandler, 'Look ma, I''m writing to a file!!!n');
UTL_FILE.FCLOSE(fHandler);
EXCEPTION
WHEN utl_file.invalid_path THEN
raise_application_error(-20000,'ERROR: Invalid path. Create directory or set UTL_FILE_DIR.');
END;
/
After typing this code i have got the error...
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 line 4
Then as per one of solution on Orafaq, I have executed below steps,
Connect User1/User1
SQL> HOST MD P:\tmp
Now again run a same code i.e.,
DECLARE
fHandler UTL_FILE.FILE_TYPE;
BEGIN
fHandler := UTL_FILE.FOPEN('DIR_EXTRACT', 'myfile.txt', 'w');
UTL_FILE.PUTF(fHandler, 'Look ma, I''m writing to a file!!!n');
UTL_FILE.FCLOSE(fHandler);
EXCEPTION
WHEN utl_file.invalid_path THEN
raise_application_error(-20000, 'ERROR: Invalid path. Create directory or set UTL_FILE_DIR.');
END;
/
Still getting same error, Please suggest,
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 line 4
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
