Re: Recompile invalid packages

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Wed, 05 Nov 2003 17:23:19 +0100
Message-ID: <3FA923F7.8060604@science-computing.de>

nobody wrote:
> 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

If you have an invalid package body, this will fail, since the correct syntax for
the recompilation of a package body is

alter package <package name> compile body;

Oops, now I gave the OP the answer instead of correctly advising to read the sql reference at tahiti.oracle.com.

Sorry ;-)

>
>
>
> P.S. Why am I unemployed ?
>

I can't think why

Regards

Holger Received on Wed Nov 05 2003 - 10:23:19 CST