Hi,
When i type in a name of a oracle package on a SQL Window, I can right click on it to select "Compare to" and select "data source.." and select a different database. I am pretty sure i used this in the past without a problem.

But now I find that it only compares the Package specification, not the package body. Basically if there a difference it shows up in examdiff otherwise it shows the message "files are identical". But they are not identical in the Body at all. I saved them and used notepad++ to compare and i find about 100 odd difference.

Whats going on please? Have i missed some check box somewhere?

Thanks
Sak
Version 12.0.2.1818 (32 bit)

We'll improve this. It does indeed make sense to compare both the specification and body when right-clicking in a source.

Maybe it does, if you think of short specs. But we have very complex specs here (Oracle eBusiness), and adding the body to the comparison wouldn't make any sense.

You mean it never used to compare the package bodies in PLSQLD? Perhaps a choice menu option to let user to choose to compare spec or body separately may help.

You can use the compare in the Object browser where you can compare the body or the specification.

The topic opening and Marcos answers seems to describe 2 different things.

To me it makes sense that when i write a packages name in sql window it should compare the specification - topic opening.
Marco talks about the source code, not the package name in an sql window.

Well, up to v11, there is no "Compare To" in SQL Window. If v12 has enabled it, and you have one source file with both spec and body, it does make sense to compare both at once. In the Program Window, though, it is better to compare only the contents from the current tab page.