ref

[truel]

Hi to all.

Is there any possibility to show a message when a package, that I try to modify, is edited at the same time by anyone? As far as I know, at the SQL Developer there's such a feature.

Thank you in advance.

 

[JKLI]

If you properly use VCS Plug-In then yes.

Basically the PL/SQL developer does not write any flag to database or somewhere to inform the other developers that a DB object is edited.

 

[Claus Pedersen]

You can experience a problem, if you try to compile a package that is in use by another session (for instance a long running job, a debug session or other) because the system would hang until the package is 'free' to compile. Is that what you mean?

I believe there is a dynamic view that can show you the objects, that are currently in use, but I can not remember the name.