Procedure still be Invalid

From: Chen Hui <chen_at_mictokyo.co.jp>
Date: Wed, 8 Jul 1998 17:06:14 +0900
Message-ID: <6nv976$oak$1@netsv03.mictokyo.co.jp>

According to Oracle application development guide, if you drop a table which a
stored procedure refers to the status of this stored procedure will change to
invalid, and if you create the table again , the status will turn back to valid.

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.

Is there anyone can tell me why and how to avoid? By the way, I use Oracle7 Server Release 7.3.2.2.1 of NT.

Thank in advance. Received on Wed Jul 08 1998 - 03:06:14 CDT