Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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
![]() |
![]() |