Invalide PL/SQL Objekte kompilieren

/* 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