Re: Recompile invalid prcedures -- help needed

an alternative is to execute

dbms_utility.compile_schema('YOUR_SCHEMA')

which takes care of all the possible dependencies ....

reagards - peter

Dr Yufan Hu <yufan_at_rightiming.com> wrote in message news:84r88a$bjh$1_at_news.rightiming.com...
> Hello,
>
> From Oracle Schema Manager I noticed from time to time that some of the
> stored procedures and Packages became invalid. Although I can recompile
> these invalid procedures from the Schema Manager by click one procedure
> after another, I would like to find out how I can do it through SQL.
> Executing the output of following SQL statement:
>
> select unique 'ALTER PROCEDURE ' || NAME || ' COMPILE;' from user_source
> where TYPE='PROCEDURE';
>
> does not seem to work. It creates more invalide procedures.
>
> Any help greately appreciated.
>
> Yufan
>
Received on Mon Jan 03 2000 - 17:20:20 CST