Re: dependecies between procedures, functions, views ...

Sybrand Bakker wrote in message
<950086493.27972.0.pluto.d4ee154e_at_news.demon.nl>...
>execute dbms_utility.compile_schema('<schemaname>')
>
>Sybrand Bakker, Oracle DBA

Yes, it's indeed the simplest way.
But I don't use it because after that I have to find out once again are any invalid objects still exist. Specialized tool of course would give you this information in convenient form right after compiling, and it also can show what it's doing.
And compile_schema routine cannot find any packages without bodies. Sometimes it's a mistaken situation :) Everything seems to be fine (all the objects are valid) but nothing works at all... After it happened to me I wrote my small compiler.

With great respect,
Dmitry Sirotkin. Received on Wed Feb 09 2000 - 03:33:13 CST