Re: Problem while compiling packages

> > news:37F63AB7.FA335F37_at_fundu.com...
> > > Hi guys,
> > > An additional thingthat I found. We had this problem when we
are running
> > > the database in the Archive Log mode. When we run it in the
noarchive
> > > mode, it seems to be fine. Any ideas wh it behaves like that in
Archivelog
> > > mode. If that is the normal behaviour, how does one makes updates
to
> > > packages in a production environment ?
> > >

Hi,
 that worked for me on 8.0.4 (solaris, aix):

1. design your packages in a tree-structure. (e.g. linear dependencies, only one parent.) this is not always possible - but try to avoid circular dependencies.
2. have separate source files for spec and body. (why: see 3.)
3. first compile all package specs (in dependency order: parents first), then all the bodies (order does'nt matter). by the time the body is compiled, there are no invalid references, and therefore no cascading re-validations.

 in a production environment, you can get the compilation order from user_dependencies. (slow query!!)

 then: alter package ... compile; alter package compile body;

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Oct 06 1999 - 05:00:54 CDT