Package Change Error

[Sanjayc]

Hi,
I am new to PL/SQL Developer software and I was recently making changes to the packages and clicked on recompile. It said recompiled successfully.

Later, when I checked by reconnecting to the PL/SQL developer, the updates to the code were not present. Are there any additional steps other than recompiling the packages for the package changes to be saved to the database and/ or are there any settings that can impact this?

Thanks in Advance.
Sanjay

 

[Marco Kalter]

When you compile a package, the new source will automatically be stored in the Oracle Data Dictionary. However, what I think happened is that instead of compiling the edited source by pressing F8 (or selecting Session > Execute), you recompiled by right-clicking on the package name and selecting "Recompile". This will recompile based on the current source definition in the dictionary. This is only useful if a program unit has become invalid.

In short: always use F8 to execute the (edited) contents of a window.