| ora-29283 invalid file operation [message #426713] |
Mon, 19 October 2009 02:06  |
lancer26
Messages: 52
Registered: May 2006
Location: Pakistan
|
Member |
|
|
hi,
i want to write text file using utl_file..
i m using windows xp sp2 and db 9i release 2.
created directory on dbserver.. \\us01db\USAPS\DTEST
my parameter UTL_FILE_DIR set to *
i created direcory as
CREATE OR REPLACE DIRECTORY
TEST_DIR AS
'\\us01db\USAPS\DTEST';
GRANT READ, WRITE ON DIRECTORY SYS.TEST_DIR TO PITS;
GRANT READ, WRITE ON DIRECTORY SYS.TEST_DIR TO PUBLIC;
i physically read and write option to file.
my code is:
DECLARE
V_HANDLE UTL_FILE.FILE_TYPE;
BEGIN
V_HANDLE := UTL_FILE.FOPEN('TEST_DIR','A.TXT','W');
utl_file .put_line(V_HANDLE, 'NATURE and Beauty');
UTL_FILE.FCLOSE(V_HANDLE);
EXCEPTION
WHEN UTL_FILE.INVALID_PATH THEN
MESSAGE(SQLCODE||SQLERRM);
WHEN UTL_FILE.INVALID_OPERATION THEN
MESSAGE(SQLCODE||SQLERRM);
END;
and then i got following error.ora-29283 invalid file operation.
anyone can help?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
