| UTL_FILE and Schedule Job problem : Need help, please! [message #73133] |
Thu, 12 February 2004 02:21 |
Martine
Messages: 2
Registered: February 2004
|
Junior Member |
|
|
Hi,
I have a scheduled job that runs every half hour to find a file in a specified directory. To do that, i use UTL_FILE.FOPEN(path,file,'r'). I catch the 'invalid_path' exception to determine if the file exists or not.
It runs several times very well but at the xth time, the job stays pending, never ends and do nothing.It seams it stays pending at the statement UTL_FILE.FOPEN. I don't know why, because the situation doesn't change in the file's directory.
Anybody can help me to resolve this problem?...
I have Oracle 8.1.6 in a Windows 2000 server.(the file is in that server).
Thanks
Martine
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
