Home » SQL & PL/SQL » SQL & PL/SQL » file write error
file write error [message #381832] Tue, 20 January 2009 01:16 Go to next message
sujata.ghatak
Messages: 6
Registered: December 2008
Junior Member
I'm trying to write in a file in server using utl_file. The file is created and more than 100 lines are wrote,but after that the below error occured....

ORA-29285: file write error
ORA-06512: at "SYS.UTL_FILE", line 18
ORA-06512: at "SYS.UTL_FILE", line 722
ORA-06512: at "XXPAYROLL.EIIL_CREATE_FORM24_DATA", line 115
ORA-06512: at line 11

here "XXPAYROLL.EIIL_CREATE_FORM24_DATA" is the stored procedure within which I'm trying.

Is there any limitation..if so is there any remedy for it.
Re: file write error [message #381843 is a reply to message #381832] Tue, 20 January 2009 01:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
No Oracle limitation.
OS error, investigate at OS level.

Regards
Michel

[Updated on: Tue, 20 January 2009 01:41]

Report message to a moderator

Re: file write error [message #381855 is a reply to message #381843] Tue, 20 January 2009 02:31 Go to previous messageGo to next message
sujata.ghatak
Messages: 6
Registered: December 2008
Junior Member
thanx,can u pls help me regarding the suggestion u've given
Re: file write error [message #381858 is a reply to message #381855] Tue, 20 January 2009 02:34 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
I don't think "u" can help you in something it didn't post.
Read OraFAQ Forum Guide and don't use IM speak.

Check OS logs.
Check permissions.
Check disk space.
Check mounts.
Check NFS.
Check ulimit.
Check anything that can lead to IO error.

Regards
Michel

[Updated on: Tue, 20 January 2009 02:34]

Report message to a moderator

Re: file write error [message #381874 is a reply to message #381858] Tue, 20 January 2009 03:18 Go to previous messageGo to next message
sujata.ghatak
Messages: 6
Registered: December 2008
Junior Member
THANX FOR YOUR COOPERATION................................
Re: file write error [message #381877 is a reply to message #381874] Tue, 20 January 2009 03:22 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Quote:
Oracle Error :: ORA-29285
file write error

Cause
Failed to write to, flush, or close a file.

Action
Verify that the file exists, that it is accessible, and that it is open in write or append mode.
Re: file write error [message #381915 is a reply to message #381874] Tue, 20 January 2009 04:52 Go to previous message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
Quote:

THANX FOR YOUR COOPERATION................................


Very nice attitude. I don't know how many times I need to repeat this again and again. Read this link on how to ask a question.

http://www.wikihow.com/Ask-a-Question-Intelligently

Coming to your problem my best guess will be as follows :

a) Check the suggestions which are already posted in this thread
b) During your file open what is the linesize you have mentioned (It is the 4th parameter) and I somehow feel you have not supplied any value to it. By default it gets substited to 1024 and if you try to write more than the mentioned linesize you will get error from oracle. Also remember the maximum linesize allowed is 32767 and you cannot go beyond this.

Having said that all these information are available in the oracle manual and without saying if you search for the error code in google you would have got an answer by this time.

Check this link from the oracle reference manual regarding utl_file.

http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/u_file.htm#BABDEJDH

Good luck

Regards

Raj
Previous Topic: arabic date to english date
Next Topic: SQL
Goto Forum:
  


Current Time: Mon Feb 10 10:56:08 CST 2025