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