Hello,
I got the following sutuation:
I wrote some changes into package body, successfully compiled and left SQL Developer opened.
On the next day I came to work, closed all the packages and connections from the GUI and opened the package again to continue.
When I tried to compile the package body, I recieved compilation errors.
The reason was: SQL Developer for some reason opened outdated package body without latest changes!
It happened several times (not constantly) and was really sudden behaviour! I lost all my work without a chance to recover.
Why it happens? Why SQL Developer remembers old packages??
PS: we work with collegue on the same package consequently, does it matter? I overwrote his changes too. He uses TOAD and never had seen such kind of problem.
Best regards,
Aidar.