Invalid Packages..

[datamart]

Hi..
I have a number of packages. A few of them are invalid. I use Embarcadero RapidSQL as a tool for querying purposes.
The problem is that when I try to validate the packages by recompiling them using the click options of the tool, one or more other packages automatically gets invalid.
I am not sure whats causing this dependecy and this is just going in loops.
Does anyone know how to resolve this kind of issue.

Thanks in advance.

 

[sem]

If your tool is clever enough then it should support selecting multiple sources to recomile. But if it is not, you may call dbms_utility.compile_scema procedure. BTW INVALID doesn't necessary means CONTAINS ERRORS thus if you know that everything's is OK (by querying USER_ERRORS) you don't need to recompile that sources manually.
As for "going in loops" (if it really goes in loops!) this is a good hint to redesign the application as your objects have cross references that is not quite well.

Regards, Dima

http://seminihin.narod.ru

 

[KenCunningham]

Slight typo in Dima's post, it's actually dbms_utility.compile_sch[/color red]ema