After Work
The best club in Chicago
for Chicago Singles is
Highlife Adventures!
Are you looking for a
Jersey Girl T-Shirt
?
Kyoto Sushi
in Chicago, on Lincoln Ave.
Moody's Pub
in Chicago, has great burgers
Skylark
in Chicago, on Halsted .. excellent Friday fish fry!
|
Oracle
»
PL-SQL
»
Procedures
»
Invalid-Fix-Rec
Oracle Procedures : Fixing Invalid Objects
Procedures can become invalid if tables are changed or moved. Here's a nice
proc which finds the invalid items and attempts to fix them. P_print
is a proc which accesses the dbms.print system proc.
CREATE OR REPLACE PROCEDURE P_fix_bad_objects
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,'SCOTT',x.object_name);
END LOOP;
END;
|
|
|
|
