Re: "OK" to loop on DBMS_SLEEP ???

I would generally use GET_TIME and look for a specific difference. But even if you find the file that does not mean, if it is a large file, that it is all there yet. I would wait a specific time period after finding the file to make sure it is completely written too.

Daniel Morgan

R Chin wrote:

> I 'm using DBMS_JOB to schedule a function to simply check if an OS file
> exists, the file may not be there just yet...
> so Im thinking of putting in a loop around DBMS_SLEEP to keep sniffing for
> few minutes....
>
> Is it "ok" to use DBMS_SLEEP to do this ? that is, is this an acceptable
> practice or Am I doing something wrong & wasting resources ?
> Thanks
> robert
Received on Mon Apr 15 2002 - 12:26:35 CDT