Home » SQL & PL/SQL » SQL & PL/SQL » uutl_file error (oracle 10g,win xp)
uutl_file error [message #322399] Fri, 23 May 2008 06:32 Go to next message
swas_fly
Messages: 220
Registered: March 2008
Location: Bhubaneswar
Senior Member
CREATE OR REPLACE PROCEDURE TEST_PROC AS
	  lv_fileHandle			UTL_FILE.FILE_TYPE ;
BEGIN
	  lv_fileHandle := UTL_FILE.FOPEN('SVEN_DATA_LOG', 'Busname_And_Consent_Summary.txt', 'w') ;
		UTL_FILE.PUT_LINE(lv_filehandle,'Busname And Consent Build Process Started on '||sysdate) ;
		UTL_FILE.PUT_LINE(lv_filehandle,LPAD(' ',100,'*')) ;
		UTL_FILE.PUT_LINE(lv_filehandle,'Number Of Records Added = 10 ');
		UTL_FILE.PUT_LINE(lv_filehandle,'Number Of Records Failed to Match = ');
		UTL_FILE.PUT_LINE(lv_filehandle,'Number Of Records Failed to find main_site flag set to Y = 5 ') ;
		UTL_FILE.PUT_LINE(lv_filehandle,'End Of Busname And Consent Build Process '||TO_CHAR(SYSDATE, 'dd/mm/yyyy hh24:mi:ss')) ;
		UTL_FILE.FCLOSE(lv_FileHandle) ;   
END  TEST_PROC ;  




SQL> exec TEST_PROC
BEGIN TEST_PROC; END;

*
ERROR at line 1:
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 475
ORA-29283: invalid file operation
ORA-06512: at "SVEN_LENIN_PROD.TEST_PROC", line 4
ORA-06512: at line 1


Elapsed: 00:00:00.83



CREATE OR REPLACE DIRECTORY
SVEN_DATA_LOG AS
'/home/edwprod/sven/sqllogs';

read,write priveleges are given Sad


How to correct this error

Thanks


Re: uutl_file error [message #322400 is a reply to message #322399] Fri, 23 May 2008 06:37 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-29283: invalid file operation
 *Cause:  An attempt was made to read from a file or directory that does
          not exist, or file or directory access was denied by the
          operating system.
 *Action: Verify file and directory access privileges on the file system,
          and if reading, verify that the file exists.

Check at OS level.

Regards
Michel
Previous Topic: How To comapre The Two Table? (merged)
Next Topic: Dynamic Generation of Trigger Code
Goto Forum:
  


Current Time: Mon Dec 05 21:10:17 CST 2016

Total time taken to generate the page: 0.14805 seconds