Re: Procedure still be Invalid

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: Wed, 08 Jul 1998 18:45:19 GMT
Message-ID: <6o0enn$24d@bgtnsc03.worldnet.att.net>

On Wed, 8 Jul 1998 17:06:14 +0900, "Chen Hui" <chen_at_mictokyo.co.jp> wrote:

>But in my enviorment, the status doesn't change back to valid after
>the process of drop table/create table until I use the
>alter procedure [name of the procedure] compile to recompile the procedure
>manually.

As I understand things, that's the way it should work. You should also be able to recreate the table and then simply call the procedure. The first time the procedure is called, Oracle will implicitly try to recompile it for you.

Jonathan Received on Wed Jul 08 1998 - 13:45:19 CDT