Re: Compiling & Executing Stored Procedures
From: Yoram zilberberg <elric_dm_at_netvision.net.il>
Date: 1996/10/21
Message-ID: <NEWTNews.845959705.3135.elric_dm_at_dialup.netvision.net.il>#1/1
Date: 1996/10/21
Message-ID: <NEWTNews.845959705.3135.elric_dm_at_dialup.netvision.net.il>#1/1
Just to add to the point stated here.
a procedure is compiled when saved. as
long as the status stays valid it does not
need to be re-compiled. Only when something happen
to an object on which the procedure is basd (like
a table or a called procedure) the procedure is
changed to not valid and will be automaticly compiled
in the next call.
You can. manualy, compile it using
"alter procedure <name> compile"
Yoram Z. Received on Mon Oct 21 1996 - 00:00:00 CEST