Getting date of file through utl file or some other means
Morning,
I have a procedure that reads a dozen or so log files and then sends me the last 10 lines of each log file in a single email with utl_file. I can easily check on batch jobs, export status etc this way in one email.
Is there anyway I can read the date of the file I am parsing?
ie, I read the entire log into a temp table, then use a little FOR loop to write out the last 10 lines of the file. What if my batch job does not run? The procedure will stil send me the log info but I will have no way of knowing whether the log is current or not.
Thanks
Steve
I'm stmontgo and I approve of this message