Re: Question: Invalid Objects

I've had this sitting in my list of scripts, havent tested it this time round. Should work for you

• Compile.sql
• Compile a schema user's invalid objects -- set echo off set feed off set term off set pages 0 spool zz.sql select 'prompt '||object_type||' '||object_name||chr(10)|| 'alter '||DECODE(object_type,'PACKAGE BODY','PACKAGE',object_type)||' '||object_name|| DECODE(object_type,'PACKAGE BODY',' compile body;',' compile;') from user_objects where object_type IN ('PROCEDURE','PACKAGE','FUNCTION','PACKAGE BODY') and status = 'INVALID' ORDER BY OBJECT_NAME; spool off set pages 66 set echo off set feed on set term on @zz

  ---

M

Ron <southbayguy_at_linkline.com> wrote in message news:<ino55v8uvahoboukhm39f8gi4uu51q5cm3_at_4ax.com>...
> I'm looking for a scipt that will look and an Oracle database for
> invalid objects (triggers, views, packages, etc...) and then allow me
> to re-compile them. Or a script that will just re-compile all invalid
> objects.
>
> Thanks in advance.
>
> Ron (southbayguy_at_linkline.com)
Received on Wed Feb 19 2003 - 02:41:14 CST