Stored Procedure recompile question
From: Kee P Luk <keeluk>
Date: 1996/01/22
Message-ID: <4e0gk5$t6n_at_senator-bedfellow.MIT.EDU>#1/1
Date: 1996/01/22
Message-ID: <4e0gk5$t6n_at_senator-bedfellow.MIT.EDU>#1/1
I have a stand-alone procedure accessing a table. After successfully compiling the procedure, I added a new column to the table. This marked the procedure as invalid by Oracle. According to the Oracle manual, it would recompile the procedure for you when you execute it. But it didn't do also. Instead, I had to use the 'alter procedure my_procedure compile' command in sqlplus to recompile the procedure. The recompilation produced no error at all.
I'm using Oracle7.
Does anyone know why it didn't recompile automatically?
Thanks
Kee Luk
email: keeluk_at_mit.edu Received on Mon Jan 22 1996 - 00:00:00 CET