OraFAQ Forum: Server Utilities » UTL_FILE and Schedule Job problem : Need help, please!

Home » RDBMS Server » Server Utilities » UTL_FILE and Schedule Job problem : Need help, please!

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Previous Topic:	URGENT! Pls. Help on Oracle Migration
Next Topic:	Question about sql*loader:

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 28 07:08:44 CDT 2025