/* Re-compiling PL/SQL Objects */
SET heading OFF;
SET feedback OFF;
SET echo OFF;
SET lines 999;
SPOOL run_invalid.sql
SELECT ‘ALTER ‘ || OBJECT_TYPE || ‘ ‘ || OWNER || ‘.’ || OBJECT_NAME || ‘ COMPILE;’
FROM ALL_OBJECTS
WHERE STATUS = ‘INVALID’
AND OWNER = USER
AND OBJECT_TYPE IN (‘PACKAGE’, ‘FUNCTION’, ‘PROCEDURE’, ‘VIEW’);
SPOOL OFF;
SET heading ON;
SET feedback ON;
SET echo ON;
@run_invalid.sql
Share this content:
Comments are closed