Oracle Forms

Hi,

I'm running with forms 10g on a windows 2003 server and I'm hitting an issue with file locking.

Part of the project functionality requires that I generate a bunch of ascii flat files to pass to a C++ dll. I'm using text_io to do this as the files need to be on the server.

Once the dll call is made, which generates further files, I need to delete out all files. The problem that I'm hitting is the deletion of these files. The files which the dll creates are cleaned up but the ones I generate using text_io seem to have a session lock on them that are preventing the files from being deleted until the session is ended.

I've tried running a host command from within the form that uses the standard dos command to delete the files. I've tried the same with a Python delete script but with no luck. I've even tried using text_io to create a temporary file and then copying that file to another using a host command but the end result is the same.

Does anyone know how i can lift this lock, short of killing the session or of another way of cleaning up the files from within forms?

Thank you in advance,

Danny