Re: Recompiling invalid objects in PL/SQL

From: Murtuja <Murtuja.Khokhar_at_gmail.com>
Date: 6 Dec 2005 21:15:35 -0800
Message-ID: <1133932535.766460.112750@g44g2000cwa.googlegroups.com>

run this query

/* Formatted on 2003/06/27 08:39 (Formatter Plus v4.5.2) */ SELECT 'ALTER '

       || DECODE (object_type, 'PACKAGE BODY', 'PACKAGE', object_type)
       || ' '
       || object_name
       || DECODE (object_type, 'PACKAGE BODY', ' COMPILE BODY;', '

COMPILE;') AS "Recompile Statement"
  FROM user_objects
 WHERE status = 'INVALID'

   AND object_type IN ('PROCEDURE',


                       'PACKAGE',

                       'PACKAGE BODY',

                       'FUNCTION',

                       'VIEW',

                       'TRIGGER',

                       'INDEX'

                      );

Received on Tue Dec 06 2005 - 23:15:35 CST