Re: recompile invalid procedures/functions without Schema Manager
From: Andrzej Zareba <anzareba_at_hotmail.com>
Date: Sat, 21 Jul 2001 21:49:02 GMT
Message-ID: <9finhf$7bd$1_at_news.tpi.pl>
where status = 'INVALID'
order by object_type;
Date: Sat, 21 Jul 2001 21:49:02 GMT
Message-ID: <9finhf$7bd$1_at_news.tpi.pl>
[Quoted] Yuo can use this Oracle Headstart scripts in servermanager or sqlplus:
set heading off
set pagesize 0
spool recompl.lst
select 'alter '||decode(object_type, 'PACKAGE BODY', 'package', object_type)
||' '||object_name
||' compile'||decode(object_type, 'PACKAGE BODY', ' body;', ';')
from user_objects
where status = 'INVALID'
order by object_type;
spool off
start recompl.lst
Andrzej Zareba.
> Michael Buresch
> How can I recompile invalid procedures/functions without Schema Manager in
> C++ or from the Servermanager?
>
Received on Sat Jul 21 2001 - 23:49:02 CEST