SQL Developer: compare procedures of two database, doesn't work ?

179018 Nov 27, 2012 9:08 AM

Hello,

I'm trying to compare procedure objects with SQL Developer (menu Tools/difference between database), but for several procedures (not all of them) this SQL Developer tools detect differences whereas there is no differences ????

I tried to "recompile" the source from the first database into the second database, but SQL Developer continue to detect difference ?

Have I missed something ?

PS: i've checked that the NLS_DATABASE_PARAMETERS and NLS_SESSION_PARAMETERS are the same for both of the database.

Thanks in advance for all tips or option to set
P. Gineste

1. Re: SQL Developer: compare procedures of two database, doesn't work ?

dz_r Nov 27, 2012 9:52 AM (in response to 179018)

Is there any difference in status of the two procedures? (one procedure has the status "valid" and the other one has the status "invalid")

If yes - look here:

Database Diff - Identical package bodies are reported as different
Like Show 0 Likes(0)

Actions
2. Re: SQL Developer: compare procedures of two database, doesn't work ?

179018 Dec 4, 2012 1:36 PM (in response to dz_r)

Thank you very much for this answer, it solved my problem
Like Show 0 Likes(0)

Actions
3. Re: SQL Developer: compare procedures of two database, doesn't work ?

rp0428 Dec 4, 2012 4:36 PM (in response to 179018)

Then please mark the question ANSWERED and give proper credit to dz for helping you.
Like Show 0 Likes(0)

Actions

Go to original post