Re: Compiling Procedures and Dependencies

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Thu, 13 May 2004 19:29:41 +0200
Message-ID: <h1c7a0986fem8vevp9nho2t9mjgoppu8nq@4ax.com>

On Thu, 13 May 2004 09:56:28 -0400, "paddy_nyr" <mpprpp_at_yahoo.com> wrote:

>I'm using Oracle 8.1.7.4 and is there a way to compile a procedure and it's
>dependencies in one statement?
>
>Thanks
>
>
>

There is no need for it. Dependent procedures will be marked invalid, and automagically be recompiled when invoked.

If you want to recompile all invalid procedures use the utl_rp.sql script in $ORACLE_HOME/rdbms/admin, connected as SYS

--
Sybrand Bakker, Senior Oracle DBA

Received on Thu May 13 2004 - 12:29:41 CDT