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; … Weiterlesen Invalide PL/SQL Objekte kompilieren