Using UTL_FILE to find files on the OS

By Steve Montgomerie – Here is how to use UTL_FILE to detect a file on the OS insead of writing a UNIX or DOS script. The procedure can be scheduled through DBA_JOBS to check for the existence of a file that has been FTP’ed, for example. Once the file has been detected, it calls another procedure to

Read More - Register for Free Membership