Database Administration (MOSC)

MOSC Banner

How to verify Source Code in Package is same as what's in an Instance

edited Sep 30, 2011 5:58AM in Database Administration (MOSC) 14 commentsAnswered ✓
Our contracted DBA has sent me one package, and my shared services director has sent a different version of a program. Which one is the correct one currently in our production instance?

I need to prove with absolute certainty the package's source is the same source, or is not the same source as the compiled object in the production instance.

Coming from an IBM background, I would simply compile the questionable source in a safe instance (library), and compare the compiled obect's size to the compiled obeject's size in the production instances. A binary size comparizon would substantiate a positive patch, or not.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center