PROMPT Pokrenuta skripta compsve.sql

SELECT DECODE (owner, UPPER ('&1'), NULL, '-- ') ||
       'ALTER ' ||
       DECODE (object_type, 'PACKAGE BODY', 'PACKAGE', object_type) ||
       ' ' || owner || '.' || object_name || ' COMPILE;' AS naredba
  FROM dba_objects
 WHERE owner IN (UPPER ('&1'), 'MISHSYS')
   AND object_type IN (
       'PACKAGE BODY',
       'FUNCTION',
       'VIEW',
       'PROCEDURE',
       'TRIGGER')
   AND status = 'INVALID'
 ORDER BY owner, object_type, object_name;
