Home » RDBMS Server » Server Utilities » UTL_FILE Buffer Overflow?
UTL_FILE Buffer Overflow? [message #158970] Wed, 15 February 2006 04:55 Go to next message
buck444
Messages: 80
Registered: January 2006
Location: Luxembourg
Member
Hi,

My UTL_FILE COPY Procedure is running fine for about 3 times. Then it stops with the error:

ORA-29283: invalid file operation


Does someone know what could happen here? It seems, the file is not closed properly, because i can't delete the file afterwards via the File System:

Cannot delete US_log: It is being used by another person or program...


The strange thing is, that it's working for 3 times and THEN the error appears. I have to KILL THE SESSION, to gain access to the file again. Then i can run my Procedure again only for 3 times.

Any ideas?



Re: UTL_FILE Buffer Overflow? [message #159119 is a reply to message #158970] Thu, 16 February 2006 05:12 Go to previous message
himang
Messages: 282
Registered: March 2005
Location: Bangalore
Senior Member

Can you post your code?
Previous Topic: data load problem !!
Next Topic: load LOB datatype !!
Goto Forum:
  


Current Time: Thu Dec 26 08:40:54 CST 2024