Is there a way to Edit Package Body compile it without compiling Specification

[sakalk]

Hi,
When i select oracle package, I can right click to edit which edits the specification part of it. Similar to that is there a way to Edit the Body only please?

The reason is when I deploy a change using Edit spec and body (both), it invalidates the other objects that refers to it, but when i deploy the package body alone it doesn't seem to happen.

Thanks
Saka

 

[patch]

You can edit just the package body.
Just open it from the object browser.
A better way is to keep the spec and body in separate files and just edit and compile the body.
If you have the spec and body in a single file or window, maybe my ExecuteCurrent plugin can help:https://patch72.com/ExecuteCurrentStatement-x86https://patch72.com/ExecuteCurrentStatement-x64

 

[sakalk]

Oh wow thats exactly what i am after. It works really well. Thanks for that.

I wish this "Edit Body only" option is available in the Right Mouse click menu as that can make my life lot easier.

 

[Nicolas D.]

You can make one.. with a plugin (We did! But I can't share that code)

 

[lost]

I use Ctrl+RClick on pkg name to open body only.
** and Ctrl-LClick to open only spec.

 

[sakalk]

Wow wow , I didnt know that existed, great tip (lost) and thanks for that.

 

[sakalk]

oh wow @lost thats a great tip. Fantastic.

 

[lost]

You're welcome, bro