Re: UTL_FILE issues

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.

Joe
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);
  END IF;





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
ORA-29283:
invalid file operation


--

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

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


Other related posts: