PL/SQL Developer - recompile

[jimpoe]

I have noticed that PL/SQL Developer is always able to recompile all invalid objects. We are trying to find a method to compile all invalid objects after a customer site installation of our application database. We always end up with invalid objects. If it is not a trade secret, what kind of script does your tool use to so effectively recompile invalid objects?

 

[Marco Kalter]

It is not really a script, it is a Delphi function. First PL/SQL Developer analyzes the dependencies (through sys.all_dependencies) between the objects, sorts them in order of dependency, and compiles them in that order.

------------------
Marco Kalter
Allround Automations

 

[jimpoe]

Thanks