We are small team of developers use SQL Developer. We usually inform each other when any of us needs to work on any stored package in order to avoid any conflict. I know this seems very primitive way, but it used to work for a while. However, recently in several incidents we seem to find a lot of code is lost out of sudden. We back up manually often but not always. Many other users use these packages with APEX application, I'm not sure if that could cause such a problem. So my question is, Is there a way to lock the package before you start updating it and release it after you finish?
Compile button in SQL Developer does not seem to store the package, often I click compile and then later I open the package to find out my recent code is gone. Is there a better way to guarantee what you've added to ultimately stored and cannot be rolledback automatically?