Home » Developer & Programmer » Forms » ora-29283 invalid file operation (oracle database 9i release 2, developer 6i,windows xp sp2)
ora-29283 invalid file operation [message #426713] Mon, 19 October 2009 02:06 Go to next message
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?
Re: ora-29283 invalid file operation [message #428757 is a reply to message #426713] Thu, 29 October 2009 18:46 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Do NOT post the same question in multiple threads!!

Answer in http://www.orafaq.com/forum/m/426709/67467/#msg_426709

David
Previous Topic: Sending Mails thru Oracle Reports(6i or 10g) on Oracle Application Server
Next Topic: HELP --> error : PDE-PLI011
Goto Forum:
  


Current Time: Tue Sep 27 14:31:33 CDT 2016

Total time taken to generate the page: 0.11445 seconds