Multiple packages compilation

Hi,

To set-up a new Oracle application (8.1.7) on a production server, I have to compile about 110 packages which are interdependent. There are even cases where package A uses package B, and package B uses package A.

What is the better solution to compile all these packages in an automated way, and obtain all the packages with a 'valid' status? Should I first compile the spec part of every package, and then the bodies? Other ideas?

Thanks,

Patrick J. Received on Wed Jan 09 2002 - 02:24:28 CST