Re: UTL_FILE issues

  • From: Joey Xu <chunhongxu@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 23 Apr 2010 14:23:23 +0800

It's specified by /session_max_open_files/ parameter.

On 2010-4-23 0:54, TESTAJ3@xxxxxxxxxxxxxx wrote:

55 files open at the same time, you are closing them when done right, it sounds like you hitting a max limit of some sorts.

Sent from the crackberry, so please excuse the typos and terseness.


*  From: *bao jiejie [baojiejie@xxxxxxxxx]
*  Sent: *04/22/2010 09:18 AM MST
*  To: *Oracle-L Group <oracle-l@xxxxxxxxxxxxx>
*  Subject: *UTL_FILE issues

Hi group,

I have a  strange things while using UTL_file package.

I have the same code running on the tables for one schema. and extract something to a file. It works good for the first 55 tables, then throw errors like below, but while you log out and relog in,and start with the error table
it works fine for the next 55 tables and throw errors like below again?

I searched oracle parameter and change all file related parameters to big value like 1000, but the error still,
Any suggestion ?

here is the lines what oracle doing at that time:

  IF NOT UTL_FILE.IS_OPEN(cmn_file_handle) THEN
cmn_file_handle := UTL_FILE.FOPEN (p_output_folder, p_output_file, 'a',32767);

here is the error I get after about fifty files be handled :

ERROR - CUSTOMER: ORA-29283: invalid file operation
ORA-06512: at
"SYS.UTL_FILE", line 41
ORA-06512: at "SYS.UTL_FILE", line 512
invalid file operation


 '7_ 7  )   '_.  (     ).'-.__.')
 (_Y_.)   ._   )  '._ '. ''-..-'
_.'--'_..-_/  /--'_.' ,'
(il),-''  (li),'  ((!.-'

Best regards,
Yours sincerely House
baojiejie@xxxxxxxxx <mailto:baojiejie@xxxxxxxxx>

Other related posts: