Custom Search
www.rocket99.com : Technical Guides Sybase Oracle UNIX Javascript


Technical Guides
Sybase
Oracle
UNIX
Javascript




Of Interest

Business Intelligence and Analytics



Oracle Training





Oracle » Administration » Fix » Invalid

Fixing Invalid Objects

     




How to fix invalid objects - procedures, packages, triggers.
Using this proc to detect and rebuild should solve many issues.





CREATE OR REPLACE PROCEDURE P_holtdw_fix_invalid
IS
CURSOR program_units IS
SELECT object_name, object_type
FROM user_objects
WHERE object_type IN
('PROCEDURE','FUNCTION','PACKAGE', 'PACKAGE BODY', 'TRIGGER')
AND object_name <> 'TEST' and status = 'INVALID' ;
BEGIN
FOR x IN program_units LOOP
P_print ( x.object_name ) ;
DBMS_DDL.ALTER_COMPILE (x.object_type,'HOLTDW',x.object_name);
END LOOP;
END;
/









Oracle : Related Topics


Sybase Web Site
Sybase iAnywhere Mobile Web Site
Oracle Enterprise Web Site



Get the latest Rocket99 news and tech tips via






Site Index About this Guide to Sybase, Oracle, and UNIX Contact Us Advertise on this site




Copyright © 2016 Stoltenbar Inc All Rights Reserved.