hi ebrin, but there are no changes reg. objects like index,views,
tables etc... but let met know if u have any more idea.
but i have to check wheather it will become invalid, when
we change procedure/function that is being called from
[QUOTE=ebriaAre privileges being changed, indexes being dropped, views being modified and/or someone changing procedures/functions/packages without you knowing it ?[/QUOTE]