Re: recompiling store proc..
Date: Tue, 18 Apr 2000 22:46:56 +0200
Message-ID: <8dihnt$4ig$1_at_news.inet.tele.dk>
Something like this should recompile invalid objects in your schema, just copy and paste the result to run it:
select 'alter ' || object_type || ' ' || object_name || ' compile;'
from user_objects
where status = 'INVALID' and
object_type != 'PACKAGE BODY';
select 'alter PACKAGE ' || object_name || ' compile body;' from user_objects where status = 'INVALID' and object_type = 'PACKAGE BODY';
HTH. Finn
Sébastien Jean <sjean_at_ca.imrglobal.com> wrote in message
news:SZ0L4.2011$vq5.97118_at_weber.videotron.net...
> Is there a way to recompile 150 store proc on the Oracle server 7.3?..
>
> instead of selected (one by one) all the stored proc, and then right click
> dans select Quick edit,.. and then... Recompile??????
>
> thanks a lot!
>
>
Received on Tue Apr 18 2000 - 22:46:56 CEST