Currently I am working on an application that runs one or more listener threads using scheduled tasks (DBMS_SCHEDULER). When I want to compile a piece of code that is effectively locked by one of these processes my IDE locks up, until I shut down the tasks. The first couple of times I was wondering what was happening and why my code wouldn’t compile. In a later stage I found out that the scheduled tasks was the problem.

It was rather easy to fix this issue. Just stop all the running listeners and my IDE frees up again. This is something that should be done more easily. If only I had only had access to an ONCOMPILE trigger. Unfortunately that doesn’t exist. Now what?!?

Read the rest of this article at http://bar-solutions.com/weblog/?p=326#more-326