7 Replies Latest reply: Feb 13, 2013 3:17 AM by 902023 RSS

    UTL_FILE fiel lock and unlock

    902023
      I'm trying to use UTL_FILE in pl/sql package to write data from a query to a text file.

      The proc crashed when debugging in Toad, and now the file is locked.
      Is there any way that I can relase the lock on the file without rebooting the server?

      Thanks,
      Regards
      Steven