Re: Recompiling invalid objects in PL/SQL

Murtuja wrote:
> 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'
> );
>

Why reinvent the wheel?

And it wouldn't recompile TYPES or OPERATORS, etc.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)