Re: Stored Proc Compile Time Stamps

Ken Shearer wrote:
>
> I've noticed that if I change the code of a stored proc and compile it,
> the last modified date/time stamp is updated. Oracle will also update the
> time stamp if the proc has gone invalid for some reason and an implicit or
> explicit compile is done.
>
> Question: If I have a stored proc (or package for that matter) that is
> still "valid" and simply do a alter/compile on it (without modifying the
> code), the last modified date/time stamp is not updated. Does oracle know
> there are no changes to the text and as a result does not really perform
> the compile? or does the compile really take place but Oracle just doesn't
> update the time stamp in this situation?

There is an undocumented

alter procedure ... compile timestamp ...

which lets you set the timestamp (or keep the existing one)

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."