file write error [message #381832] |
Tue, 20 January 2009 01:16  |
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 #381915 is a reply to message #381874] |
Tue, 20 January 2009 04:52  |
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
|
|
|