Re: PL/SQL Problem

Not particularly better, but different:

rem compile.sql - recompiles all invalid database objects rem change the spool path to whatever you want spool /opt/oracle/admin/adhoc/runthem.sql SELECT 'ALTER ' || OBJECT_TYPE || ' ' || OWNER || '.' || OBJECT_NAME || ' COMPILE;' FROM DBA_OBJECTS
WHERE STATUS = 'INVALID'
/

spool off;

@/opt/oracle/admin/adhoc/runthem.sql

--
-cheers
  DW
--------------------------------------------------------------------
"It is a kind of good deed to say well; and yet words are not deeds.
  -William Shakespeare"


Sent via Deja.com
http://www.deja.com/