Ignore white space in compare user objects?

[Brian Baker]

I would like to be able to ignore whitespace when comparing objects from two different sessions. When I compare some of our packages, several are listed as having differences. When I run ExamDiff I can specify that it (ExamDiff) should ignore the whitespace but I don't see a way to do that from within the PLSQL Developer IDE.

It also seems odd that there would be any whitespace differences at all -- since we simply export the packages using "Export User objects" and then run the script on the target schema...

 

[ScottMattes]

Our packages have recently started loosing blank lines (lines so loving put in for readability I might add). Something in the way, or the setup, of the folks who are the only ones allowed to do the compiling.

How do you 'run the script on the target schema'?

 

[Brian Baker]

Originally posted by ScottMattes:
How do you 'run the script on the target schema'?

Normally I will use the Export User objects to export all packages and package bodies to a single file. Then I click the view button, log on to the other session, and execute the file.

 

[Marco Kalter]

The Compare User Objects function already ignores whitespace. Unless they occur within a character string.