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