Re: Compiling Packages and Forms 5.0

Mark --

One thing I have found when working with packages and forms is that if the packages are recompiled for ANY reason (whether or not there was a change or not) the forms have had to be recompiled...."bug" or "feature", I'm not sure, but it's what I've encountered.

Project Builder (with Developer 2.1) helps tremendously --- it "knows" which forms have to be recompiled, and compiles only those.

As for speeding up the compilation, I've found that several small packages are better than one huge one. (I generally do a "lookup" and an "admin" for each module.)

HTH
Louise
Mark S. Reichman wrote in message <36f016ad.0_at_news.rlcn.rl.af.mil>...
>Sorry if this shows up twice. I dont think our news server was
>working yesterday and it decided not to post the original.
>
>I have a package in the database and Oracle Forms that call
>functions withing this package. Sometimes, not everytime, I recompile
>the package some of the forms break. I have even witnessed form
>errors based upon functions that were never edited, only recompiled
>with the package. I really dont want to have to recompile my forms
>everytime I recompile packages in the database. I find it hard to
>believe this is so... I dont want the forms to complain about the
>functions unless they are actually missing or the paramaters have changed.
>Whats going on here?
>
>Secondly, are there any tricks to speed up compiling packages?
>Maybe some SQL set command or memory settings?
>
Received on Sat Mar 27 1999 - 10:53:14 CST