Put yourself together a script to look at user_objects (or all_objects)
where the object_type is a package, proc or function, and the status is
invalid. Spool these names wrapped in the text to alter <type>.<name>
compile; then have that same script run the spooled file. I can e-mail you
what I use if you want it.
DerWoud
Jan Kjetil wrote in message <356938E2.F2CB4862_at_nextel.no>...
>I have a database with many dependencies among the packages with PL/SQL
>code.
>When a package is recompiled the dependent code packages are set
>to invalid even if the compiled package is valid.
>
>Does anybody know about any recompiling tool for Oracle which can
>be helpful in this situation?
>
>
>jka_at_nextel.no
>
Received on Sat May 30 1998 - 23:44:20 CDT
