Re: UTL_FILE and locking

Hi Paul,

get on over to www.sysinternals.com and check out the tools there, i would guess they have something to check if the file is locked at the OS level. This is an excellent site for windows monitoring type tools. If not search google for a utility to check for file locking.

On the other hand can you use a lock file instead?, if so create a lock file using utl_file first before you do file access and then delete it after all the other file operations have taken place. I don't know what BCI is but maybe you could wrapper its calling to check the lock file first.

If you are on 9iR2 you can delete the lock file from the utl_file package if before use dbms_backup_restore.deletefile. You will need to grant access to this package as its default is no access granted.

hope this helps

Kind regards

Pete

-- 
Pete Finnigan
email:pete_at_petefinnigan.com
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.